NexQLv2.4.0

Reference

All 325 commands.

Generated from the NexQL 2.4.0 extension manifest. Every command is listed in the Command Palette (Ctrl+Shift+P, or Cmd+Shift+P on macOS) unless the manifest hides it; the other places it appears are shown beside it. Commands marked Pro are part of NexQL Pro.

325 of 325 commands

Connections & safety 24

Add, edit, duplicate, pin, group and color connections, import one from a DATABASE_URL in a .env file or from a URL on the clipboard, and connect, reconnect or disconnect. Switch the connection or database a notebook uses, or set a default connection for the workspace. Sentinel settings control how the editor signals which environment you are on (title bar, status bar, notebook strip, tab badges), and the Production audit log is listed here too.

11 settings in this area →

Profiles 5

Create, switch and delete connection profiles, and export them to a file or import them from one.

Explorer & objects 59

Refresh the tree, search schema objects, add objects to favorites, and open properties, definitions and data for tables, views, functions, types, roles, foreign objects and more. The Definition Viewer (DDL viewer) settings control the SQL preview. Auto refresh settings control how often the tree and Notebooks panel poll PostgreSQL for changes.

4 settings in this area →

Object management 101

Create, edit and drop database objects, enable or disable triggers, truncate tables, grant and revoke privileges, schedule pg_cron jobs, and run VACUUM, ANALYZE and REINDEX. The Operations commands are per-object menus that group these actions.

Scripts & templates 27

Generate SQL from a selected object: SELECT, INSERT, UPDATE and DELETE scripts, CREATE and ALTER scripts, and templates for columns, constraints and indexes. The Call Function and Call Procedure commands are here too.

Notebooks & queries 18

Create and organise notebooks, open them quickly, jump between sections, and open the Query Tool, Query Studio or a psql session. Settings cover the query timeout, what happens when a statement in a batch fails, prompted parameters, and the SQL formatter.

11 settings in this area →

Results & export 4

Export table data and notebooks, and toggle full dataset mode on a cell. Settings cover the automatic LIMIT, the default row limit, sliding-window streaming for large results, and how bytea columns are shown.

5 settings in this area →

Saved queries & history 17

Save queries to a library, search, load, edit, copy and delete them, import and export the library, and see query recommendations. Query History entries can be opened, copied or deleted, and the whole history cleared.

1 setting in this area →

Schema tools 13

Design tables visually, view entity-relationship diagrams, compare schemas, import data and DBML, and open the Migration Hub. The database index commands and settings build and manage the local index of your database structure.

2 settings in this area →

Performance & Plan Studio 9

Run EXPLAIN and EXPLAIN ANALYZE on a query, view index usage, table activity, table profiles and column statistics. A setting sets the threshold for flagging a query as slow in history and results.

1 setting in this area →

Dashboard 4

Open the live database dashboard for a connection and database, and open the LISTEN/NOTIFY monitor.

AI / NexQL Bot 9

Open NexQL Bot in the sidebar or an editor tab, attach objects and queries to a chat, use Ask AI on a notebook cell, generate or optimize a query, and reveal an object in the explorer from the bot. Settings choose the provider and model for chat and notebooks, set the context budget, and configure the OpenCode integration.

19 settings in this area →

Backup & restore 3

Back up a database, restore one, or open the Backup & Restore workspace and choose a connection and database.

Sync 21

Set up sync, run it on demand or pause it, pull or push only, preview what would change, and resolve conflicts. Share items with a workspace, invite members and choose items to leave out. Repair, rebuild-index and diagnostics commands are listed too. Settings cover automatic sync, the notebook folder, the pull interval and the API endpoint.

5 settings in this area →

Settings, license & help 6

Open the settings hub and What's New, and manage your license: activate it, manage it, view plans and show free usage.

Diagnostics 5

Turn on verbose logging to the NexQL Debug output channel, choose a telemetry mode (off, basic or detailed) and tune what is sent, and show a database's configuration.

8 settings in this area →