Importing and Exporting Connections
Move Oracle connection profiles into Nexo SQL Studio or between Nexo installations.
Importing and Exporting Connections
Use the Connections Explorer import and export actions to reuse connection metadata instead of recreating every profile. Review the selected file format carefully because SQL Developer and Nexo handle passwords differently.
Import from Oracle SQL Developer
- In Oracle SQL Developer, export the connections you want to transfer in its JSON connections format.
- In Nexo SQL Studio, run Import Connections from the Connections Explorer.
- Select Oracle SQL Developer export.
- Choose the exported
.jsonfile. - Review and select the connections to import.
Nexo reads supported connection metadata from the JSON export and recreates SQL Developer navigation folders. It also preserves supported editor colors as folder or connection presentation data.
Saved SQL Developer passwords are not imported. SQL Developer encrypts exported passwords using a format that Nexo cannot decrypt safely, so encrypted password values are ignored. After import, edit or connect each profile, enter its database password, and enable Save password if you want Nexo to store it.
An import may therefore reproduce connection names, database addresses, usernames, connection options, folders, and colors while still requiring credentials. Unsupported SQL Developer-specific properties are ignored.
Import a Nexo export
Choose Nexo connections export and select a .nexoconn file. Current Nexo exports are protected by a passphrase; enter the same passphrase that was used when the file was created.
The import can restore selected:
- Connection profiles and credentials
- Nested connection folders and colors
- Per-connection AI/MCP policies
- APEX and ORDS base URLs
- Default deployment targets
You can review the connection list and import only the profiles you need. Existing and imported folder structures are merged for the selected connections.
Export Nexo connections
Run Export Connections from the Connections Explorer and select the profiles to include. Nexo writes a .nexoconn file and asks for a passphrase of at least 12 characters.
The passphrase encrypts the connection snapshot, including exported database credentials, using authenticated encryption. Store and transfer the file as sensitive material even though it is encrypted. The passphrase is not recoverable from the export and should be shared through a separate secure channel.
Metadata-only sharing
Do not assume an exported connection file is safe to publish. A profile can reveal internal hostnames, service names, usernames, deployment targets, and environment organization even without a usable password.
For documentation or support, share only the individual non-sensitive fields that are required. Remove credentials, wallet secrets, private addresses, and production details before attaching connection data.
After an import
- Open each imported profile and confirm its connect identifier and username.
- Enter any password that was not transferred.
- Click Test before saving changes.
- Review production status, inherited folder safeguards, and AI/MCP permissions.
- Connect and expand the object tree to confirm that the account reaches the expected schema.