Generated reference
Commands and settings.
This page is generated from vscode-extension/package.json at build time, so
names, identifiers, defaults, and descriptions stay aligned with the extension.
Commands
| Command | Identifier |
|---|---|
| PostgreSQL Workbench: Add Server | postgresql-workbench.addServer |
| PostgreSQL Workbench: Set Database Context Active | postgresql-workbench.useDatabaseContextAsActive |
| PL/pgSQL: Start Local Debug Database (Docker) | postgresql-workbench.startDockerDebugDatabase |
| Remove Server | postgresql-workbench.removeServer |
| Connect | postgresql-workbench.connectServer |
| Disconnect | postgresql-workbench.disconnectServer |
| Edit Server | postgresql-workbench.editServer |
| Change Password | postgresql-workbench.changePassword |
| PL/pgSQL: Pick Connection | postgresql-workbench.pickConnection |
| PL/pgSQL: Refresh | postgresql-workbench.refreshTree |
| PL/pgSQL Workbench: Reindex Active Database | postgresql-workbench.indexActiveDatabase |
| PostgreSQL Workbench: Configure Schema Synchronization | postgresql-workbench.configureWorkbenchSchemaSync |
| PostgreSQL Workbench: Provision Schema Synchronization | postgresql-workbench.provisionWorkbenchSchemaSync |
| PostgreSQL Workbench: Remove Schema Synchronization Provisioning | postgresql-workbench.removeWorkbenchSchemaSyncProvisioning |
| PostgreSQL Workbench: Search Database Objects | postgresql-workbench.searchDatabaseObjects |
| Open PostgreSQL Definition | postgresql-workbench.openDatabaseObject |
| Reveal PostgreSQL Object in Workbench Tree | postgresql-workbench.revealDatabaseObjectInTree |
| Open PostgreSQL Cockpit | postgresql-workbench.openDatabaseGraph |
| PostgreSQL Object Actions... | postgresql-workbench.showObjectActions |
| PostgreSQL Workbench: Execute SQL Selection | postgresql-workbench.executeSqlSelection |
| PostgreSQL Workbench: New SQL Scratchpad | postgresql-workbench.newSqlNotebook |
| Open SQL Scratchpad | postgresql-workbench.openSqlNotebook |
| Rename SQL Scratchpad | postgresql-workbench.renameSqlNotebook |
| Delete SQL Scratchpad | postgresql-workbench.deleteSqlNotebook |
| Duplicate SQL Scratchpad | postgresql-workbench.duplicateSqlNotebook |
| Export SQL Scratchpad... | postgresql-workbench.exportSqlNotebook |
| Refresh SQL Scratchpads | postgresql-workbench.refreshSqlNotebooks |
| PostgreSQL Workbench: Rebind Scratchpad | postgresql-workbench.changeSqlNotebookConnection |
| PostgreSQL Workbench: Reconnect Scratchpad Binding | postgresql-workbench.reconnectSqlNotebook |
| PostgreSQL Workbench: Use Binding as Active | postgresql-workbench.useSqlNotebookBindingAsActive |
| PostgreSQL Workbench: Compare Routine with Database | postgresql-workbench.compareRoutineWithDatabase |
| PL/pgSQL: Refresh pgTAP Tests | postgresql-workbench.refreshTests |
| Show pgTAP Tests | postgresql-workbench.revealRoutineTests |
| PL/pgSQL: Export Last Coverage | postgresql-workbench.exportCoverage |
| PL/pgSQL: Check Server Requirements | postgresql-workbench.checkRequirements |
| Terminate Debug Sessions... | postgresql-workbench.manageDebugSessions |
| Debug | postgresql-workbench.debugFromTree |
| Open Source | postgresql-workbench.openFunction |
| PL/pgSQL: Debug Function/Procedure | postgresql-workbench.debugDefinition |
| PL/pgSQL: Debug Call | postgresql-workbench.debugCall |
| PL/pgSQL Results: Copy Captured Result | postgresql-workbench.results.copy |
| PL/pgSQL Results: Export Captured Result | postgresql-workbench.results.export |
| PL/pgSQL Results: Clear History | postgresql-workbench.results.clear |
Settings
| Setting | Default | Description |
|---|---|---|
postgresql-workbench.workbench.schemaSync.enabled | false | Opt in to automatic PostgreSQL schema synchronization for DatabaseContexts without an explicit connection override. Provisioning remains a separate confirmed action. Data changes (DML) never trigger synchronization. |
postgresql-workbench.workbench.schemaSync.supportSchema | "workbench" | PostgreSQL schema containing the Workbench DDL notification functions. Event triggers remain database-level objects and are not contained by this schema. |
postgresql-workbench.workbench.codeMoniker.commandTimeoutMs | 30000 | Maximum duration in milliseconds for one Code Moniker daemon command used by Workbench indexing, navigation, graph queries, and debugger syntax analysis. Changes apply to the next extension session. |
postgresql-workbench.results.maxRows | 200 | Maximum number of PostgreSQL rows retained for SQL selections and debug results. It is also used as the notebook page size when results.pageSize has not been configured explicitly. |
postgresql-workbench.results.pageSize | 200 | Number of rows loaded initially and by each Next action for cursor-backed SQL notebook results. |
postgresql-workbench.results.maxCachedRows | 1000 | Maximum number of cursor-backed notebook rows retained for Previous navigation. Load all explicitly bypasses this limit. |
postgresql-workbench.results.cursorIdleTimeoutSeconds | 300 | Close an idle PostgreSQL notebook result cursor after this many seconds. |
postgresql-workbench.results.nonPagedMaxRows | 200 | Maximum rows retained for notebook statements that cannot be paged safely, including data-modifying statements with RETURNING. |
postgresql-workbench.results.autoReveal | true | Automatically reveal the PL/pgSQL Results panel without taking keyboard focus when a debugged SQL call completes or fails. |
postgresql-workbench.tests.patterns | ["*_ut.test_*","*_it.test_*"] | Glob patterns used to discover pgTAP test functions, matched against schema.function. Matching functions must return SETOF text; zero-argument functions can be run automatically. Schemas containing matched tests are treated as test infrastructure for coverage mapping. |
postgresql-workbench.coverage.include | [] | Glob patterns for routines eligible for coverage, matched against schema.name(identity arguments). An empty list includes all discovered routines. |
postgresql-workbench.coverage.exclude | [] | Glob patterns for routines excluded from coverage, matched after the include patterns. |
postgresql-workbench.coverage.maxRoutines | 200 | Maximum number of PL/pgSQL routines instrumented by one coverage request. |
postgresql-workbench.coverage.maxOutputLines | 200 | Maximum number of TAP output lines attached to each VS Code test result. |
postgresql-workbench.coverage.maxOutputBytes | 1048576 | Maximum TAP payload retained for one pgTAP test. Individual rows are truncated in PostgreSQL before transmission. |
postgresql-workbench.coverage.maxParallelDatabases | 2 | Maximum number of independent PostgreSQL databases covered in parallel. |
postgresql-workbench.coverage.timeoutMs | 300000 | Maximum duration in milliseconds for one database coverage suite, including rollback and cleanup. |