GudDB
A lightweight, fast database client for VS Code. Connect to PostgreSQL, MySQL, and SQLite databases directly from your editor.
Features
Database Explorer
Browse your database structure in the sidebar — connections, databases, schemas, tables, views, and columns all in a navigable tree.
Table Data Viewer
Click any table to browse its data with:
- Pagination with configurable page size
- Column sorting
- Inline filtering with SQL WHERE clauses
- Inline cell editing (double-click any cell)
- Row selection, insert, duplicate, and delete
- Syntax-highlighted query bar
Query Editor
Open .sql files with full IntelliSense:
- SQL keyword completions
- Table and column name suggestions
- Syntax highlighting
- Run queries with
Ctrl+Enter (Cmd+Enter on Mac)
- Results displayed in a dedicated grid panel
Export
Export query results or table data to:
- CSV — comma-separated values
- JSON — array of objects
- SQL — INSERT statements
Choose scope (current page, all rows, selected rows, or custom limit) from the built-in export modal.
AI Natural Language to SQL
Describe what you want in plain English and get SQL generated automatically.
- Copilot — uses VS Code's built-in language model API (requires Copilot subscription)
- Anthropic Claude — uses the Claude API (requires API key)
Trigger with Ctrl+Shift+G (Cmd+Shift+G on Mac) from any .sql file.
Supported Databases
| Database |
Driver |
Status |
| PostgreSQL |
pg |
Full support |
| MySQL / MariaDB |
mysql2 |
Full support |
| SQLite |
better-sqlite3 |
Full support |
Getting Started
- Install GudDB from the VS Code Marketplace
- Click the database icon in the activity bar
- Click + to add a connection
- Fill in your connection details and click Save
- Click a table to browse data, or right-click to open a query editor
Configuration
| Setting |
Default |
Description |
guddb.maxResultRows |
1000 |
Maximum rows displayed in query results |
guddb.tableView.pageSize |
50 |
Rows per page in table data viewer |
guddb.ai.provider |
copilot |
AI provider: copilot, anthropic, or disabled |
Keyboard Shortcuts
| Shortcut |
Action |
Ctrl+Enter / Cmd+Enter |
Run SQL query |
Ctrl+Shift+G / Cmd+Shift+G |
Natural language to SQL |
License
MIT
