Frequently Asked Questions
Query, explore and develop with Oracle, PostgreSQL, MySQL, MariaDB, SQLite and Microsoft SQL Server in VS Code. Nexo SQL Studio combines a database client with dedicated Oracle SQL and PL/SQL tooling.
Oracle Database, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft SQL Server. Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.
Yes. Nexo supports six database engines and retains dedicated advanced Oracle tooling, including Oracle connection settings and SQL/PLSQL development workflows.
Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.
Free covers core SQL workflows. Pro adds advanced development, delivery and AI/MCP tools. A Pro license does not make an unsupported engine feature available.
Yes. Select the corresponding engine when creating a connection. SQLite uses a local file; server databases use their connection details. Consult the engine guide for requirements and feature availability.
Hosted databases: use the engine's connection settings. Supabase uses PostgreSQL; Oracle Cloud and Autonomous Database use Oracle. Poolers, wallets, authentication and provider-specific services need their own configuration and compatibility checks.
Ordinary Oracle connections use the bundled Thin driver and do not require Oracle Instant Client. Thick-mode or external-authentication workflows may require additional Oracle client configuration.
Yes. Free is available without login. Sign in only when you want to activate and validate the single all-inclusive Pro license.
Nexo SQL Studio is designed for modern Oracle Database workflows, including Oracle 19c, 21c, 23ai, and the newer 26ai naming used by Oracle. We recommend validating critical workflows against your own database version and drivers.
Nexo SQL Studio follows industry-standard security practices and takes advantage of VS Code security measures plus the native encryption systems provided by each operating system. Keep your machine, VS Code, and database client tooling updated for the strongest protection.
No SQL text, database credentials, schema/object names, file paths, result contents, or arbitrary user text are sent through usage telemetry. Free usage metrics are limited to allowlisted feature events such as feature attempts or upgrade-dialog views. Connections are made between your machine and the database systems you configure.
AI, MCP, the companion, SQL optimization, agent workflows, and data-modeling assistance are Pro features. When activated, they can help search database context, execute queries you approve, compile objects, inspect errors, and create data models for your database workflows.
Statements are executed only when you trigger a workflow or approve an AI-agent action. Some features read database metadata to power navigation, completions, and object browsing.
You can always open and edit local SQL/PLSQL files and use snippets. Nexo offline autocomplete, object/project generation, synchronization, validation, and deployment workflows require Pro, even when the files were downloaded by another tool.
Ordinary Oracle connections use the bundled Thin driver and do not require Oracle Instant Client. Thick-mode or external-authentication workflows may require additional Oracle client configuration.
Check the selected engine, host or file path, database name, account permissions and TLS requirements. Keep the connection editor open while correcting failed tests. Include the engine, server version, extension version and a sanitized error when requesting support; never include passwords or wallet secrets.