QuickDB

🚀 Why QuickDB?

QuickDB turns VS Code into a powerhouse database management tool. Whether you're inspecting data, visualizing relationships, or letting AI write your queries, QuickDB provides a seamless, context-rich experience without ever leaving your editor.

✨ Key Features at a Glance

• Universal Database Support: Connect to PostgreSQL, MySQL, SQLite, MongoDB, and Redis—all from a single unified interface.
• AI-Ready with Built-In MCP Server: Instantly expose your database schema and data to AI agents like Cursor, Claude Desktop, Antigravity, Windsurf, and more.
• Visual Query Builder: Construct complex queries, joins, and aggregations visually—no SQL required.
• Powerful Table Manager: Create, modify, and visualize your schema with an intuitive UI.
• Relationship Navigation: Follow foreign keys by clicking—jump to a referenced row or list every row that references it, no manual JOINs.
• Data Visualization: Instantly chart any query result into stunning, exportable Ant Design Plots graphs.
• Import & Export: Move data easily between SQL dumps, JSON, CSV, and Excel.

📸 See It in Action

Database Management & Imports

Easily connect to your servers and import data seamlessly.

Visual Query Builder

Build complex SQL queries visually without writing code.

Connect with External AI Clients

Connect QuickDB to your favorite AI assistant (Cursor, Claude Desktop, JetBrains AI, Windsurf, Continue, etc.) in just a few clicks:

1. Open the Setup Panel: Press Cmd+Shift+P (macOS) or Ctrl+Shift+P (Windows/Linux) and run QuickDB: Setup MCP Server.
2. Select Connections: Choose which databases you want the AI to have access to.
3. Copy Snippet: Click "Copy snippet" on the card matching your AI client.
4. Paste & Restart: Paste the JSON into your client's config file and restart the client.

🏁 Getting Started

📦 Installation

1. Open VS Code and navigate to the Extensions view (Ctrl+Shift+X or Cmd+Shift+X).
2. Search for "QuickDB".
3. Click Install on the QuickDB extension.

Note: After installation, a new QuickDB icon will appear in your Activity Bar (left sidebar). Click it to open the connections view.

⚡ Quick Start (Adding a Database)

Follow these steps to connect your first database:

1. Open the Panel: Click the QuickDB icon in the sidebar.
2. Add a Connection: Click the + icon at the top of the panel, or run QuickDB: Add Connection from the Command Palette.
3. Provide Details: Select your database engine (PostgreSQL, MySQL, MongoDB, SQLite, or Redis) and fill in your connection credentials.
4. Test & Save: Click Test connection to verify your details, then click Create connection to save it.
5. Explore: Your new database will appear in the tree view. Expand it and click any table to start browsing and editing data!

Supported Databases

QuickDB supports 54 driver families spanning SQL, NoSQL, graph, time-series, vector, file-format, stream, and cloud-analytics engines.

SQL & Relational

Cloud Analytics & Data Warehouses

NoSQL / Document

Message Streams & Queues

Time-Series, Search & Graph

Vector

File Formats

Protocol-compatible engines

Engines that speak the MySQL or PostgreSQL wire protocol connect through the same drivers — pick them by name in the connection form:

Connection Management

Adding a Connection

1. Open the QuickDB sidebar
2. Click the + button or run QuickDB: Add Connection
3. Select the database type from the available options
4. Fill in the required fields, then Test connection and Create connection

Color Coding

Assign a color to each connection for quick visual distinction:

Production connections (red) show a warning indicator in the tree view.

Editing, Removing & Filtering

• Edit: Right-click a connection → Edit Connection
• Remove: Right-click a connection → Remove Connection
• Refresh: Right-click a connection → Refresh, or press F5
• Filter tables: Type in the Find table… input below the connection name to filter the table list live.

Table Viewer

The Table Viewer is the primary data browsing interface. Click any table in the sidebar tree to open it.

View Modes

Editing Data

• Edit a cell: Click on a cell and type the new value
• Add a row: Click + Add in the toolbar or press Ctrl+N
• Delete rows: Select rows, then click - Delete or press Del
• Set NULL: Right-click a cell → Set NULL (Ctrl+Alt+N)
• Save: Click Save or press Ctrl+S; Preview SQL (Ctrl+P) shows the generated DML before applying.

Relationship Navigation

QuickDB reads foreign keys from your schema (SQLite, MySQL, PostgreSQL) and turns key cells into clickable links — no manual JOINs. Hover a cell to reveal the relationship actions:

• Jump to the referenced row (↗): On a foreign-key cell, opens the parent table in a new tab, pre-filtered to that key.
• Show referencing rows (branch icon): On a primary-key cell, opens the child table filtered to rows that point back to this one.

Inferred relationships: For schemas without declared foreign keys (MongoDB especially), QuickDB infers links by naming convention — a column like user_id is matched to the users collection (with singular/plural handling). Declared foreign keys always take precedence.

Query Console

Run arbitrary queries against your database.

Toolbar

Destructive statements (DROP TABLE, DROP DATABASE, TRUNCATE, and unscoped DELETE / UPDATE) prompt for confirmation before running.

Editor

• Context-aware autosuggest offers only what's valid at the cursor — tables after FROM/JOIN, columns after SELECT, etc. Use Ctrl/Cmd+Space to force open; Tab / Enter accepts.
• Type table. to list that table's columns instantly.
• Foreign-key JOIN completion offers related tables with a ready-made ON clause.
• Live, dialect-aware validation flags unknown tables/columns, unbalanced parens, = NULL, cross joins, and more, underlining the offending word.
• Smart error fixes suggest the closest real identifier (Did you mean …?) or hand the failing query to the @quickdb chat assistant.

MongoDB

1db.users.find({"role": "admin"})2db.users.insertOne({"name": "Alice", "role": "user"})3db.users.aggregate([{"$group": {"_id": "$role", "count": {"$sum": 1}}}])

Supported methods: find, findOne, insertOne, insertMany, updateOne, updateMany, deleteOne, deleteMany, countDocuments, aggregate, distinct.

Redis

1GET mykey2SET mykey "hello world"3HGETALL myhash4LRANGE mylist 0 -15ZRANGE myzset 0 -1 WITHSCORES

Visual Query Builder

Build complex SQL queries visually without writing code.

Features

• Drag-to-join: drag from a column in one table to a column in another to wire up the ON clause.
• Custom subqueries: use a custom SQL subquery as the main table or a joined table.
• Joins: INNER, LEFT, RIGHT, FULL — configure type, columns, and aliases.
• Filters (WHERE / HAVING): nested AND/OR groups with operators =, !=, <, >, LIKE, IN, BETWEEN, IS NULL, …
• Sorting & pagination: drive ORDER BY and LIMIT/OFFSET from the column picker.
• SQL Preview + Results side-by-side, separated by a draggable splitter.

Table Manager

Create and modify database tables with a visual interface.

Creating a Table

1. Right-click a connection → Create Table
2. Enter the table name
3. Add columns with name & type, primary key / auto-increment, nullable / unique constraints, default values, comments, check constraints, and generated columns.

Index Management

• View all indexes for a table
• Create new indexes (unique or non-unique)
• Drop existing indexes

Import & Export

Move data between QuickDB and .sql / .json / .csv / .xlsx files. Right-click a connection for Export Database / Import Database, or a table for Export Table / Import to Table.

Export

• SQL — schema + data dump (toggle DROP statements / schema-only).
• JSON — one file containing every selected table.
• CSV — one CSV file per table.
• Excel (xlsx) — one workbook with one sheet per table.

Import

• SQL — replays statements (uses the native mysql/psql/sqlite CLI when available, falling back to the internal parser).
• JSON / XLSX / CSV — streamed into the destination database with bounded memory usage.

Data Compare

Compare data between two tables or connections.

1. Open via the Command Palette: QuickDB: Compare Data
2. Select source and target connections/tables
3. View differences highlighted in the comparison grid

Copy to Database

Copy table data from one database to another.

1. Open via the Command Palette: QuickDB: Copy to Database
2. Select the source table
3. Choose the target connection and copy options, then Execute

Data Visualization

Chart any query result, save the chart, and download it as PNG / SVG / HTML / spec JSON. The same engine renders charts inside the extension and answers AI requests via the MCP server.

Two modes

• Template mode (default): pick a chart type (bar, line, area, pie, scatter, histogram, heatmap, boxplot, …) and map columns to X / Y / Group-by / Aggregation.
• Spec mode: paste any config from the Ant Design Plots gallery; your data fills data automatically.

Download formats

MCP Server Integration

QuickDB includes a Model Context Protocol (MCP) server that enables AI tools to interact with your databases.

Available MCP Tools

Safety rules

• quickdb_execute_query allows only read forms: SELECT, SHOW, DESCRIBE, EXPLAIN, VALUES, TABLE, and WITH … SELECT.
• quickdb_execute_write refuses DROP DATABASE/DROP SCHEMA, TRUNCATE, and unscoped DELETE / UPDATE by default. Set QUICKDB_ALLOW_DESTRUCTIVE=1 to opt out.
• quickdb_update_rows / quickdb_delete_rows require a non-empty filter.
• Row cap: structured read tools are hard-capped at 500 rows per call (default 100).
• Per-call timeout: every query has a wall-clock timeout (default 30 s), overridable via QUICKDB_QUERY_TIMEOUT_MS.

Environment variables (stdio server)