GudDB - Database Client

The database client for Cursor, Windsurf, VS Code, and any compatible editor. Connect to PostgreSQL, MySQL, MariaDB, SQL Server, MongoDB, ClickHouse, ElasticSearch, CockroachDB, and SQLite — without leaving your editor.

Ask your database in plain English

Every connection has a one-click ✨ Ask AI button. Describe what you want, get runnable SQL against your real schema — powered by OpenAI, Claude, or local models with Ollama (free and private, nothing leaves your machine).

Ask AI, right in the tree	Choose any AI provider

Why GudDB?

Everything below is free — including things other database extensions charge for or limit:

• ✅ Inline data editing — free (paid elsewhere)
• ✅ Export to CSV / JSON / SQL — free (paid elsewhere)
• ✅ SSH tunnels — free (paid elsewhere)
• ✅ Unlimited connections — free (limited elsewhere)
• ✅ Lightweight and fast — no separate app, no Electron, no telemetry

Features

Connect with a URI or JDBC URL

Paste a connection string and GudDB auto-detects the database type and fills in all fields:

• postgresql://user:pass@host:5432/mydb
• mysql://user:pass@host:3306/mydb
• mssql://user:pass@host:1433/mydb
• mongodb://user:pass@host:27017/mydb
• jdbc:postgresql://host:5432/mydb?sslmode=require

Or fill in host, port, user, and database manually. All server connections support an optional SSH tunnel (key or password).

Database Explorer

Browse your database structure in the sidebar — connections, databases, schemas, tables, views, and columns in a navigable tree.

• Filter tables, views, and columns by name with Ctrl+Alt+F (Cmd+Alt+F on Mac)
• Right-click a table for View Structure, Alter Table, and Drop Table
• Right-click a database/schema for Create Table (interactive column editor)

Table Data Viewer

Click any table to browse and edit its data:

• Pagination with configurable page size, column sorting, and inline WHERE filtering
• Inline cell editing — double-click any cell
• Row selection with insert, duplicate, and bulk delete
• View full value — expand any cell into a modal with Raw / JSON / SQL views; JSON is pretty-printed and syntax-highlighted
• Wrap toggle to see long multi-line values at once
• Preview tabs — browsing tables reuses one tab; it auto-pins once you edit, so tabs don't pile up
• Syntax-highlighted query bar with autocomplete

Query Editor

Open .sql files with full IntelliSense:

• Keyword, table, and column completions — mixed-case/reserved identifiers are inserted already quoted so queries don't fail
• Syntax highlighting
• Run with Ctrl+Enter (Cmd+Enter on Mac)
• Raw result view for output like SHOW CREATE TABLE — toggle between table and raw text

Query History

Every query you run is saved to the Query History panel with its connection, row count, duration, and timestamp. Click to re-open, right-click to copy or delete.

Export

Export query results or table data to CSV, JSON, or SQL INSERT statements — choose current page, all rows, selected rows, or a custom limit.

AI Natural Language to SQL

Describe what you want in plain English and get SQL generated automatically — the AI sees your actual schema, so it uses your real table and column names.

Where to find it: every connected database shows a ✨ Ask AI item right in the tree — one click. Also: the sparkle button at the top of the Connections view, right-click any connection, or Ctrl+Shift+G (Cmd+Shift+G on Mac) in a .sql file.

Pick your AI — run GudDB: Configure AI Provider for guided setup:

API keys are stored securely in your OS keychain, never in settings files.

Supported Databases

All server-based databases support SSH tunneling — connect through a bastion host with key or password authentication.

Getting Started

1. Install GudDB from the VS Code Marketplace or Open VSX
2. Click the database icon in the activity bar
3. Click + to add a connection
4. Paste a connection string or fill in details manually, then click Save
5. Click a table to browse data, or right-click for structure and query actions

Configuration

Keyboard Shortcuts

Support

GudDB is free. If it saves you time, consider supporting development:

Report bugs and request features at github.com/gudlab/guddb-database-client/issues.

License

Proprietary - free to use. See LICENSE file for details.