AI-Powered Database Assistant  ·  7-day free trial

Your complete
database workbench
powered by AI

Chat with your data in plain English, run and format SQL in a tabbed editor, browse live grids, build sharable dashboards, back up databases — all from one professional tool.

7-day free trial Cancel at any time AES-256-GCM encrypted credentials OpenAI · Anthropic · OpenRouter
MySQL
MariaDB
PostgreSQL
SQL Server
SQLite

Everything you need to
work with databases

Professional AI database tooling for MySQL, PostgreSQL, MSSQL, MariaDB & SQLite — built for developers, analysts, and teams.

🤖

AI Chat Interface

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.

🗂️

Tabbed SQL Editor

Open 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.

🔦

Index Advisor

Write 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.

📊

Live Data Grid

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.

🔒

Safe Mode

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.

One-click protection
💬

Chat Tabs & History

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.

🔗

Multiple Connections

Save unlimited database connections, switch between them from the toolbar, and manage credentials anywhere. Each connection stores passwords with AES-256-GCM encryption.

🔍

Grid Filtering & Sorting

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 & Drop

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.

📋

Row Copy & Paste

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.

🌳

Schema Explorer

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.

📏

Resizable Panes

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.

📡

Context Window Meter

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.

💾

5 Database Types

MySQL, MariaDB, PostgreSQL, SQL Server, and SQLite — each with the correct query syntax, identifier quoting, parameter style, and connection options including SSL/TLS.

🔄

Auto-Refresh Widgets

Configure 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.

📦

Backup & Restore

Generate a full gzipped SQL dump of any database with one click. Download it locally or restore from any previously uploaded .sql or .sql.gz file — all browser-based, no CLI needed.

Gzip · Upload restore · No CLI
🪄

AI Table Wizard

Describe the table you need in plain English and the AI generates a complete, dialect-correct CREATE TABLE statement with proper data types, constraints, and indexes — ready to run.

Dialect-aware · All 5 DB types

Capability by capability

Scroll through each major feature with live UI previews showing exactly what you'll work with.

Write, run, and fix SQL like a pro

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.

  • Run with ▶ Run or Ctrl+Enter
  • Selected text only runs the highlighted portion
  • Auto-appends LIMIT to stray SELECTs so you never pull the whole table
  • AI Fix opens the corrected query in a new tab with a diff explanation in chat
  • Format SQL pretty-prints any query with one click
  • ⚡ Index Advisor generates CREATE INDEX statements for any slow query
🖊️ Editor USE: ecommerce
Console
🤖 AI Fixed
⚡ Indexes
-- Analyse revenue by product category
SELECT
  p.`category`,
  SUM(oi.`subtotal`) AS revenue,
  COUNT(*) AS orders
FROM `order_items` oi
JOIN `products` p USING(`product_id`)
GROUP BY p.`category`
ORDER BY revenue DESC LIMIT 500;
✓ 12 row(s) returned · 4 ms

Multiple chat sessions, full history

Run parallel AI conversations in separate tabs — query analysis in one, schema design in another. Every SELECT the AI generates populates the data grid automatically.

  • Context bar shows exactly which databases and tables the AI can see
  • Every SQL block has a ▶ Run button — execute directly from chat
  • Closed tabs are saved to history with titles and timestamps
  • Restore any past session as a new tab in one click
  • Context window usage bar shows token consumption in real time
💬 AI Chat
Top customers
Schema review
Show me the top 5 customers by lifetime spend
Here's the query:
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;
▶ Run ⎘ Copy

Browse, edit, filter, and sort live data

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.

  • Double-click any cell to edit it inline — changes write back immediately
  • Per-column filter bar with contains / exact match toggle per column
  • Click any column header to sort ascending → descending → none
  • Select rows with checkboxes, then copy, paste into another table, or delete
  • Query execution time shown as Time taken X.XXXXXXX seconds
📊 ecommerce.customers Time taken 0.0042100 seconds
id 🔑 ⇅name ⇅email ⇅ltv ▼
1Alice Johnsonalice@ex.com£4,280
2Bob Smithbob@ex.com£3,105
3Carol Whitecarol@ex.com£2,870

Safe mode and schema explorer

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.

  • Safe Mode blocks all non-SELECT queries and grid edits with a clear warning
  • Sidebar search filters databases and tables as you type
  • Expand any table to see columns with data types and all index definitions
  • Drag any item from the tree into the SQL editor at cursor position
  • Expand / collapse all databases with a single click
🗄️ Schema Explorer 🔒 Safe mode ON
▶ 🗄️ ecommerce
+ customers ▶ Grid
- orders selected ▶ Grid
🔤 Columns
order_id int(11) 🔑 PK
customer_idint(11)
totaldecimal(10,2)
⚡ Indexes
PRIMARY(order_id)
idx_customer(customer_id)

Save queries, build charts, share dashboards

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.

  • Save queries with a name, description, and tags — encrypted at rest
  • Widget types: bar, line, area, pie, doughnut, stat (KPI), and table
  • Configure X and Y axes per widget; support multiple Y series on one chart
  • Drag widgets to reorder; resize each to 25%, 33%, 50%, 66%, 75%, or 100% width
  • Set each widget to auto-refresh every N seconds for live monitoring
📈 Dashboard — Revenue Overview
£84,320
Total Revenue
STAT
1,243
Orders This Month
STAT
Revenue by Category BAR
Electronics
Clothing
Books
Home
🔄 Auto-refresh: 30s 4 widgets

Share dashboards with a public link

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.

  • One-click share key generation per dashboard
  • Public view runs queries live against your database on each load
  • Auto-refresh works on the shared view too
  • Revoke access instantly — the link stops working immediately
  • Shared view shows all widget types: charts, stats, and tables
🔗 Share Dashboard
Revenue Overview
Public share link
https://app.webdbpro.com/share/aB3xK9mRqZpL…
📋 Copy link 🔄 Regenerate 🚫 Revoke
Anyone with this link can view live charts — no login needed
Shared view active · last loaded 2 min ago

One-click backups, browser-based restore

Protect your data with gzipped SQL dumps generated straight in the browser. No command-line tools needed — download the backup file, then restore from any .sql or .sql.gz file by uploading it.

  • Select any database and click Download Backup — gzip-compressed SQL dump
  • Backup includes table structure, indexes, and all data rows
  • Upload a .sql or .sql.gz file to restore to any connection
  • Statement-by-statement execution with live progress log
  • Works across all 5 supported database types (MySQL, MariaDB, PG, MSSQL, SQLite)
📦 Backup & Restore — ecommerce
ecommerce MySQL
💾 Download Backup
Gzipped SQL dump · all tables
⬇ Download
🔄 Restore from file
Drop .sql / .sql.gz here or browse
✓ CREATE TABLE `customers` … OK
✓ INSERT INTO `customers` (1000 rows) … OK
⟳ INSERT INTO `orders` (3420 rows) …

Design new tables with plain English

Don't remember the exact syntax for your database type? Describe the table you need and the AI generates a complete, dialect-correct CREATE TABLE statement with the right data types, constraints, primary keys, and indexes.

  • Describe columns, relationships, and constraints in plain English
  • Output is dialect-specific: MySQL, MariaDB, PostgreSQL, MSSQL, or SQLite
  • Includes primary keys, foreign keys, unique constraints, and recommended indexes
  • Generated SQL opens in a new editor tab — ready to review and run
  • Iteratively refine by adding follow-up requirements in the same session
🪄 AI Table Wizard
Create a products table with a UUID primary key, name, description, price in pence, stock quantity, and timestamps. Link it to a categories table.
Here's a MySQL CREATE TABLE for products:
CREATE TABLE `products` (
  `id` CHAR(36) NOT NULL,
  `category_id` INT UNSIGNED NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `description` TEXT,
  `price_pence` INT UNSIGNED NOT NULL DEFAULT 0,
  `stock_qty` INT NOT NULL DEFAULT 0,
  `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP
                ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_category` (`category_id`),
  CONSTRAINT `fk_prod_cat`
    FOREIGN KEY (`category_id`)
    REFERENCES `categories`(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
▶ Open in Editor ⎘ Copy

Your personal SQL library, encrypted

Save any SQL query with a name, description, and tags. Queries are encrypted at rest, tied to specific connections, and instantly loadable into any editor tab — perfect for recurring reports, maintenance scripts, and frequently-run analytical queries.

  • AES-256-GCM encryption of query SQL at rest in the database
  • Associate each query with a connection and a target database
  • Load into editor tab with one click — no copy/paste
  • Pin saved queries as dashboard widgets for visualisation
  • Manage all saved queries from a dedicated library panel
💾 Saved Queries
Monthly Revenue Report 📊 In dashboard
ecommerce · production-mysql
SELECT DATE_FORMAT(created_at,'%Y-%m') …
▶ Load ✏ Edit
User Sign-ups by Day tag: analytics
users_db · production-mysql
SELECT DATE(created_at), COUNT(*) …
▶ Load ✏ Edit
🔑 All SQL encrypted with AES-256-GCM at rest

Bring your own API key

Connect to any of the three supported AI providers. Keys are stored with AES-256-GCM encryption and never appear in logs.

OpenAI GPT-4o, GPT-4.5, GPT-5 and more · live model list
Anthropic Claude Opus, Sonnet, Haiku families
OpenRouter GPT, Claude, Gemini, Llama, Mistral & more

Switch models at any time from the header dropdown — no page reload required.

Ask anything about your data

Just type what you want to know and WebDBPro generates the correct SQL syntax for your database type — and explains every decision.

WebDBPro – MySQL · ecommerce Context: 3.2k / 128k (2%)
You: Show me the top 10 customers by total order value this month
AI: Here's the query to get your top customers by revenue this month:
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;
-- Uses MySQL backtick quoting · indexed on customer_id and created_at
▶ Run ⎘ Copy
You: The query is slow — what indexes should I add?
AI: Based on your schema, the following indexes will speed this query significantly:
-- 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`);
-- Both indexes together cut query time from ~850ms to ~12ms in a typical dataset

Up and running in minutes

Create your account

Register with your email and choose the plan that fits — Individual for solo developers, Company Individual for professionals, or Team for shared access.

Connect your AI provider

Add your OpenAI, Anthropic, or OpenRouter API key. Keys are encrypted before storing. Test the connection with one click.

Add a database connection

Enter your host, port, credentials and select the database type. Passwords are AES-256-GCM encrypted. Test before saving.

Start chatting & querying

Select a database in the sidebar, ask the AI anything, run queries with Ctrl+Enter, browse results in the live data grid.

Simple, transparent pricing

Choose the plan that fits your workflow. Cancel at any time.

Monthly Annual Save ~20%

Individual

£14.99/mo
£10.39/mo
Billed annually · £14.99/mo  ·  £124.70/yr total
Perfect for solo developers
  • 1 user licence
  • Up to 5 saved connections
  • All features included
  • 🔑 AI requires your own API key
Start free trial

Team (5 seats)

£239.20/mo
£239.20/mo
Billed annually · £299.00/mo  ·  £2,870.40/yr total
For teams who need shared access and control — annual billing only
  • 5 user licences
  • Unlimited saved connections
  • All features included + dedicated support
  • 🔑 AI requires your own API key
Start free trial

See full pricing details →

🔑 AI features require your own API key from OpenAI, Anthropic, or OpenRouter — not included in the subscription price.

Why choose WebDBPro over the competition?

WebDBPro is the only tool to combine AI-first queries, live dashboards, Safe Mode, localhost tunneling, and AES-256-GCM security — all in a browser, no install required.

🧠

AI is core, not an add-on

Chat with your database in plain English from day one. Schema-aware SQL generation, AI Fix, Index Advisor, and AI Table Wizard — not a plugin or subscription upsell.

📊

Dashboards built in

Build shareable, auto-refreshing dashboards from your saved queries. DataGrip, DBeaver, phpMyAdmin, Adminer and MySQL Workbench offer none of this natively.

🌐

No install, any device

DataGrip, DBeaver and MySQL Workbench all require a desktop install. WebDBPro works instantly in any browser — your connections and history follow you everywhere.

🛡️

Safe Mode — no accidental writes

One-click Safe Mode blocks all non-SELECT statements and disables grid edits. No other tool in this comparison offers this protection out of the box.

🔌

Localhost tunneling

Connect the Desktop Agent and reach localhost or private network databases from the web app over an encrypted WebSocket — no port-forwarding or firewall rules needed.

🔐

AES-256-GCM encryption

Credentials, API keys, and saved queries are encrypted server-side. phpMyAdmin and Adminer only hold credentials in a web session — nothing persisted securely.

See the full feature comparison →

Ready to work smarter with your databases?

Join developers and teams already using WebDBPro to query, explore, optimise, back up, and share data faster with AI.

🖥️

Download WebDBPro for Windows

Prefer a desktop app? Download the Windows installer and manage your databases locally — connection credentials are stored in an encrypted file on your machine, never sent to a server.

🔒 Web version: connections are stored server-side with AES-256 encryption and require a subscription account.  ·  💻 Desktop version: connection credentials are encrypted locally — saved queries, dashboards and sharing require switching to a server-stored connection inside the app.

Download for Windows (.exe)

Version 1.0.0  ·  Windows 10 / 11 (64-bit)

Frequently Asked Questions

Everything you need to know about WebDBPro — from getting started to security and billing.

About the Product
WebDBPro is an AI-powered database workbench that lets developers, analysts, and teams interact with their databases using plain English. It supports MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, and SQLite. You can chat with your database via OpenAI, Anthropic, or OpenRouter; run SQL in a tabbed editor with AI Fix and Format; browse and edit live data in a grid; build visual dashboards with charts; back up and restore databases — all from one web-based or desktop tool.
WebDBPro supports five major SQL database engines: MySQL, MariaDB, PostgreSQL, Microsoft SQL Server (MSSQL), and SQLite. Each engine is handled with dialect-correct SQL — including backtick quoting for MySQL/MariaDB, double-quote identifiers for PostgreSQL and MSSQL, and the appropriate connection options including SSL/TLS support.
WebDBPro is built for software developers who need a fast SQL editor with AI assistance, data analysts who query databases daily, database administrators managing multiple connections, and teams who want to share live dashboards. Typical use cases include query optimisation, schema exploration, live database monitoring, ad-hoc analysis, database backup and restore, and rapid table design using the AI Table Wizard.
When you start a chat session WebDBPro reads your database schema — tables, columns, data types, and indexes — and passes it as context to the AI. You type a question in plain English, such as "show me the top 10 customers by revenue this month", and the AI generates dialect-correct SQL using your exact table and column names. Every SQL block in the chat has a ▶ Run button to execute directly into the data grid. The AI also supports follow-up questions, index suggestions, query fixes, and table design.
Yes. WebDBPro does not bundle AI credits or a shared key. You must connect your own API key from OpenAI (GPT-4o, GPT-4.5, GPT-5 etc.), Anthropic (Claude Opus, Sonnet, Haiku), or OpenRouter (access to GPT, Claude, Gemini, Llama, Mistral and more via one key). Your key is encrypted with AES-256-GCM before storage and is never exposed in server logs.
Features & Usage
After logging in, open the Connections panel and click Add Connection. Enter your database host, port, username, password, and select the database type (MySQL, MariaDB, PostgreSQL, MSSQL, or SQLite). Your password is encrypted with AES-256-GCM before being saved. Click Test Connection to verify connectivity, then Save. The connection appears immediately in the sidebar and the schema explorer loads your databases and tables automatically.
Yes. The AI chat interface generates complete, ready-to-run SQL from natural language. Because the AI has your schema loaded as context it uses your actual table and column names, applies the correct SQL dialect, and adds the appropriate JOINs, GROUP BY, and ORDER BY clauses automatically. The Index Advisor feature also generates CREATE INDEX statements for any slow query to help optimise performance.
Yes. The SQL editor includes two AI-powered tools. AI Fix analyses a broken query, corrects syntax errors, aligns column references to your actual schema, and opens the corrected query in a new editor tab with an explanation in the chat. AI Format pretty-prints any SQL with consistent indentation and capitalisation in a single click.
Yes. The live data grid lets you open any table from the schema sidebar or view query results in a sortable, filterable grid. Double-click any cell to edit it inline — changes write back to the database immediately. You can insert new rows, delete selected rows, and copy rows from one table and paste into another. Per-column filter inputs support contains and exact match modes.
Security & Data Protection
Database passwords are encrypted using AES-256-GCM (Advanced Encryption Standard, 256-bit key, Galois/Counter Mode with authentication) before being stored. The encryption key is a server-side secret that is never exposed to the client. Passwords are never logged or transmitted in plaintext. On the Windows desktop app, credentials are stored in an encrypted local file on your machine rather than any server.
AI API keys are stored encrypted using AES-256-GCM and are never logged or exported in plaintext. Saved SQL queries are also encrypted at rest using AES-256-GCM. Chat history is stored per-session so you can restore past conversations, but no data is shared with third parties or used to train AI models. You can delete your saved queries, chat history, and account at any time.
Yes. The Safe Mode toggle in the database toolbar restricts execution to SELECT queries only. All INSERT, UPDATE, DELETE, DROP, ALTER, and TRUNCATE statements are blocked with a clear warning. Safe Mode also disables inline cell editing and row deletion in the data grid — ideal for exploratory analysis or when sharing screen access with others.
Features & Usage (continued)
Yes. The Backup & Restore panel generates a gzip-compressed SQL dump of any database with one click — no command-line tools or mysqldump installation required. The backup includes all table structures, indexes, and data rows. To restore, upload any .sql or .sql.gz file and WebDBPro executes it statement by statement with a live progress log. Works across all five supported database types.
Yes. The built-in Dashboard Builder lets you save any SQL query as a named widget and pin it to a dashboard. Supported chart types include bar, line, area, pie, doughnut, stat (KPI card), and table. Widgets support multiple Y-axis series, configurable auto-refresh intervals, drag-and-drop reordering, and flexible sizing. Public share links let anyone view a live read-only dashboard without logging in.
WebDBPro provides two main export options. For a full database export, use the Backup feature to download a gzip-compressed SQL dump (.sql.gz) containing all table schemas and data. For query result export, the data grid includes a CSV export button that downloads the current result set as a comma-separated values file. You can also copy selected rows to the clipboard for pasting into spreadsheet applications.
Pricing & Trials
Yes. WebDBPro offers a 7-day free trial on all plans — Individual, Company Individual, and Team. No credit card is required to start. You get access to every feature during the trial period, including AI chat, the SQL editor, live data grid, dashboards, backup and restore, and saved queries. You will need to provide your own AI API key to use AI features.
WebDBPro offers three plans:

Individual — £14.99/month (or £10.39/month billed annually). 1 user, up to 5 saved connections, all features.

Company Individual — £79.99/month (or £55.99/month billed annually). 1 user, unlimited connections, all features.

Team (5 seats) — £239.20/month, annual billing. 5 users, unlimited connections, all features, dedicated support.

All plans require your own AI API key. View full pricing →
Yes. You can cancel your subscription at any time from the billing portal in your account settings. Cancellation takes effect at the end of the current billing period — you retain full access to all features until that date. There are no cancellation fees or lock-in periods on monthly plans.
Troubleshooting
The most common causes are: (1) the database server is not publicly accessible — many cloud databases require you to whitelist the WebDBPro server IP in your firewall or security group; (2) incorrect host, port, username, or password; (3) the database user lacks the required privileges; (4) SSL/TLS is required by the server but not enabled in the connection settings; (5) the database name is wrong or the user has no access to it. Use the Test Connection button to see the exact error message.
First, confirm you have copied the complete API key without any whitespace. Check that the key has not expired or been revoked in your provider's dashboard (OpenAI, Anthropic, or OpenRouter). Make sure you have selected the correct provider in WebDBPro's AI settings — an OpenAI key will not work if Anthropic is selected. Use the Test Key button to validate the key without saving. For OpenRouter, ensure your account has sufficient credits and the selected model is available on your plan.