pgconsole’s SQL editor is a workspace for writing queries, browsing schemas, and working with results. What sets it apart:
- Understands your SQL — syntax highlighting, autocomplete, formatting, error detection, and function signature help are all backed by a PostgreSQL parser, not regex.
- Guardrails — database access control and audit logs ensure every query is authorized and recorded.
- AI assistant — generate, explain, fix, and rewrite SQL with an AI assistant that understands your schema context.
Editor
SQL Intelligence
The editor parses your SQL in real-time to provide:
- Autocomplete — context-aware suggestions for tables, columns, joins, and CTEs (
Ctrl+Space)
- Formatting — pretty-print or collapse to one line
- Error detection — red underlines with hover tooltips; optionally Fix with AI
- Code folding — collapse
SELECT, WITH, and other blocks
Quick SQL Generation
When a table or view is selected in the schema browser, the Quick SQL menu generates SQL templates and inserts them into the editor:
INSERT, UPDATE, DELETE, CREATE TABLE, and ALTER ADD COLUMN are only available for tables (not views).
Data Grid
Query results appear in the panel below the editor in a virtual-scrolling grid that handles large result sets efficiently.
Navigation
| Action | Behavior |
|---|
| Click a row | Open the row detail panel |
| Double-click a cell | Start editing that cell |
j / ↓ | Select next row |
k / ↑ | Select previous row |
Space | Pin or unpin the selected row |
Inline Editing
With write permission, you can modify data directly in the grid. All changes are staged locally — nothing is committed until you explicitly execute.
| Action | How |
|---|
| Edit a cell | Double-click the cell, or click the row and press Edit in the detail panel |
| Add a row | Click the + button in the results toolbar |
| Delete a row | Right-click and select Delete, or use the Delete button in the detail panel |
| Duplicate a row | Right-click and select Duplicate (primary key fields cleared) |
Data Export
- Export to CSV — downloads visible rows as a CSV file (requires
export permission)
- Copy as Markdown — copies results as a markdown table to the clipboard
Schema Inspection
Schema tabs provide detailed inspection of database objects.
Active Sessions
The Processes button in the toolbar opens a modal showing active database connections. The list auto-refreshes periodically. With admin permission, a Terminate button appears on each row with a confirmation countdown.
