Chat with your data in plain English, run and format SQL in a tabbed editor, browse live grids, get index recommendations, and more — all from one professional tool.
Professional database tooling powered by AI — built for developers, analysts, and teams.
Ask questions in plain English. The AI understands your schema and generates correct, optimised SQL for your specific database dialect — MySQL backticks, PostgreSQL identifiers, and all.
Connect your own OpenAI, Anthropic Claude, or OpenRouter API key. Switch models on the fly from the header dropdown. Your key is stored encrypted, never logged.
OpenAI · Anthropic · OpenRouterOpen multiple SQL tabs at once — one for your slow query analysis, another for schema changes. Tabs persist across page reloads so you never lose your work.
Paste a broken query and click AI Fix — the AI corrects syntax errors, aligns identifiers to your schema, and explains changes. Format pretty-prints any SQL instantly.
One-click improvementWrite any slow query, click ⚡ Indexes, and get AI-generated CREATE INDEX statements with explanations — opened in a new editor tab ready to copy and run.
Browse table data in a responsive grid. Double-click any cell to edit inline. Insert new rows, delete selected rows, and save changes back to the database without writing SQL.
Toggle Safe Mode on to allow only SELECT queries. All write operations — INSERT, UPDATE, DELETE, DROP — and grid edits are blocked, protecting your data during exploration.
Run multiple AI chat sessions side by side, each with its own context and message log. Closed chat tabs are saved to history automatically — restore any past session in one click.
Save unlimited database connections, switch between them from the toolbar, and manage credentials anywhere. Each connection stores passwords with AES-256-GCM encryption.
A global search bar and per-column filter inputs let you drill into any result set instantly. Toggle between contains and exact match modes per column. Click any header to sort.
Drag any database name, table name, or column from the sidebar directly into the SQL editor at your cursor position. Drag column headers from the grid into the editor too.
Select one or more grid rows, copy them to clipboard memory, and paste into another table. Duplicate-key conflicts are handled automatically by retrying with a fresh auto-increment ID.
The sidebar tree shows every database and table on your connection. Expand any table to browse its columns with types and its indexes — without writing a single query.
Drag the divider between the SQL editor and AI chat panel, or between the editor area and data grid, to customise your workspace layout for any task or screen size.
A visual progress bar in the header shows how much of the AI's context window your current session is using — colour-coded green → amber → red so you always know when to start a new chat.
MySQL, MariaDB, PostgreSQL, SQL Server, MongoDB, and SQLite — each with the correct query syntax, identifier quoting, parameter style, and connection options including SSL/TLS.
Save any SQL query with a name, description, and tags. Queries are encrypted at rest and tied to a connection. Load them instantly from the editor — no searching through history.
Encrypted at restTurn saved queries into visual widgets — bar, line, area, pie, doughnut, stat, or table. Arrange them on a drag-and-drop dashboard. Set each widget to auto-refresh on a custom interval.
Bar · Line · Pie · Stat · TableGenerate a public share link for any dashboard. Anyone with the link can view your live charts and data without logging in. Revoke access at any time with a single click.
Public read-only linkConfigure each dashboard widget to re-run its underlying query automatically every N seconds. Keep KPI dashboards and monitoring views live without any manual page refresh.
The built-in editor supports multiple tabs — keep your ad-hoc queries in one tab, schema changes in another, and index suggestions in a third. Everything persists across reloads.
LIMIT to stray SELECTs so you never pull the whole tableRun parallel AI conversations in separate tabs — query analysis in one, schema design in another. Every SELECT the AI generates populates the data grid automatically.
SELECT c.name, SUM(o.total) AS ltv FROM customers c JOIN orders o USING(customer_id) GROUP BY c.customer_id ORDER BY ltv DESC LIMIT 5;
The bottom pane holds a full-featured data grid. Open any table from the sidebar, run a query, or watch it populate automatically from an AI chat response.
| id 🔑 ⇅ | name ⇅ | email ⇅ | ltv ▼ | |
|---|---|---|---|---|
| 1 | Alice Johnson | alice@ex.com | £4,280 | |
| 2 | Bob Smith | bob@ex.com | £3,105 | |
| 3 | Carol White | carol@ex.com | £2,870 |
The sidebar tree lets you drill into every database, table, column, and index without writing a query. Enable Safe Mode to eliminate the risk of accidental writes during exploration.
Save any SQL query with a name and tags, then pin it to a dashboard as a visual widget. Charts run directly against your live database — always up to date.
Generate a unique share key for any dashboard. The recipient opens the link in a browser and sees a live read-only view — charts refresh, no login required. Revoke the link at any time.
Connect to any of the three supported AI providers. Keys are stored with AES-256-GCM encryption and never appear in logs.
Switch models at any time from the header dropdown — no page reload required.
Just type what you want to know and WebDBPro generates the correct SQL syntax for your database type — and explains every decision.
SELECT c.`customer_id`, c.`name`, SUM(o.`total_amount`) AS `total_revenue` FROM `customers` c INNER JOIN `orders` o ON c.`customer_id` = o.`customer_id` WHERE o.`created_at` >= DATE_FORMAT(NOW(), '%Y-%m-01') GROUP BY c.`customer_id`, c.`name` ORDER BY `total_revenue` DESC LIMIT 10;
-- Index on orders.created_at for the date filter CREATE INDEX idx_orders_created_at ON `orders` (`created_at`); -- Composite index to cover the JOIN + GROUP BY CREATE INDEX idx_orders_customer_date ON `orders` (`customer_id`, `created_at`, `total_amount`);
Register with your email and choose the plan that fits — Individual for solo developers, Company Individual for professionals, or Team for shared access.
Add your OpenAI, Anthropic, or OpenRouter API key. Keys are encrypted before storing. Test the connection with one click.
Enter your host, port, credentials and select the database type. Passwords are AES-256-GCM encrypted. Test before saving.
Select a database in the sidebar, ask the AI anything, run queries with Ctrl+Enter, browse results in the live data grid.
Choose the plan that fits your workflow. Cancel at any time.
Join developers and teams already using WebDBPro to query, explore, and optimise data faster with AI.