Give Your AI Agent Your Prod Database. Safely.
Local databases, sandboxes, dry runs, per-database rules, review and undo. All built in for your coding agent.
- 100+ commands in one palette ⌘K
- 90+ schema, performance and health checks
- 50+ agent tools, with a dry run and backup before prod changes
Download for macOS
7-day free trial · No credit card · Then $49 once, no subscription
Works with Claude Code Codex Cursor OpenCode
Every engine
One App, and One Plugin, for Every Database You Run
PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, ClickHouse, CockroachDB and Cloudflare D1, plus the platforms built on them. You and your agent get the same connections.
PostgreSQL
MySQL
SQLite
SQL Server
MariaDB
CockroachDB
ClickHouse
PostgreSQL
MySQL
SQLite
SQL Server
MariaDB
CockroachDB
ClickHouse
PostgreSQL
MySQL
SQLite
SQL Server
MariaDB
CockroachDB
ClickHouse
PostgreSQL
MySQL
SQLite
SQL Server
MariaDB
CockroachDB
ClickHouse
PostgreSQL
MySQL
SQLite
SQL Server
MariaDB
CockroachDB
ClickHouse
PostgreSQL
MySQL
SQLite
SQL Server
MariaDB
CockroachDB
ClickHouse
Supabase
Neon
PlanetScale
Cloudflare D1
Raycast
Apple Spotlight
Supabase
Neon
PlanetScale
Cloudflare D1
Raycast
Apple Spotlight
Supabase
Neon
PlanetScale
Cloudflare D1
Raycast
Apple Spotlight
Supabase
Neon
PlanetScale
Cloudflare D1
Raycast
Apple Spotlight
Supabase
Neon
PlanetScale
Cloudflare D1
Raycast
Apple Spotlight
Supabase
Neon
PlanetScale
Cloudflare D1
Raycast
Apple Spotlight
For you
This Isn't an AI Chatbot Stapled to a Query Editor
TableStudio uses your live schema as context - so when you ask "show me orders over $500 last week", it knows your column names. No guessing. Bring your GitHub Copilot subscription or any OpenAI-compatible endpoint and tune model, temperature, and system prompts per connection.
- Schema-Aware AI ChatAsk questions against your actual tables and columns. No hallucinated column names, no generic guesses - just working SQL from an AI that knows your database.
- Natural Language BrowseFind records in any table using plain English. TableStudio generates SQL in the right dialect for whichever database you are connected to, runs it, and shows you the rows.
- Bring Your Own ModelAlready paying for GitHub Copilot or Codex? Connect it here. Tune model, temperature, and system prompt per connection.
The Index You're Missing Is Costing You Every Request
Dead tuples, unused indexes, bloated tables, missing keys - they accumulate quietly in every engine until they don't. TableStudio watches your real query patterns and surfaces exactly what's missing, with estimated speedup percentages before you apply anything.
- Index Suggestions, EarnedBased on your real query patterns - not heuristics. Estimated speedup shown before you apply. One click to review, one click to run.
- ER Diagrams You Can Talk ToAsk how orders reach payments and the diagram highlights the path. Your agent can open it too, centered on the table it's working on.
- Schema Diffs That MatterCompare dev vs staging vs production side by side. Spot drift before it becomes an incident.

Localhost, Finally in Plain Sight
Postgres.app and Homebrew start a server and leave you guessing whether it's even running. TableStudio picks up the Postgres, MySQL, and ClickHouse servers already on your Mac, data untouched, or creates fresh ones. Start and stop them, launch them at login, back them up to your Mac or S3, and see uptime, connections, disk use, and every database at a glance.
- Let Your Agents Run It TooClaude Code, Cursor, or any MCP client can list, start, stop, and spin up local databases on their own. Starting, stopping, and creating are separate permissions, so an agent only gets what you allow.
- Logs Without the HuntNo more digging through ~/Library or brew paths. The server log sits right next to the stats, so a failed start explains itself.
- Share It With a TeammateOpen a Cloudflare Tunnel to any local server and send them the connect command. Guard it with a Cloudflare Access policy and switch it off when you're done.

Your Keyboard Should Run the Show
⌘K opens a context-aware command palette that knows where you are and what you're doing. Switch connections, run queries, open migrations, compare schemas - without touching your mouse.
- Context-Aware CommandsThe palette adapts to what you have open. In the query editor? You get query actions. In the schema browser? Schema actions.
- Everything, InstantlyConnect to a database, jump to a table, trigger a backup, open the ER diagram - any action in the app, one keystroke away.
- Fuzzy Search Across EverythingTableStudio, connections, recent queries, migrations - all searchable from one place. No hunting through menus.
Agent Center
See Everything Your Agent Did With Your Data
Every conversation, from every agent, in one window: which agent, which repo, which chat, and each call it made. What it read, what it dry-ran, what it proposed and what TableStudio stopped. Open Chat takes you straight back to the conversation.
- Every Call, by ConversationCalls are filed under the chat that made them, so you can follow a session from its first question to its last change.
- What Was Stopped, and WhyA production write, a write without a dry run, a function with side effects. The agent is told the safe route, and you see the attempt.
- It Stays on Your MacThe record lives in TableStudio's own files for 30 days. The plugin only ever talks to TableStudio on localhost.

Undo
Every AI Change Comes With an Undo
Before your agent changes a row, TableStudio saves the rows it's about to touch, including the ones a foreign key cascades to, on every engine. Undo that one change from the Agent Center without restoring the whole database. Schema changes save the schema first, and a change it can't save row by row gets a full restore point or goes to your review.
- Undo One Change, Not the Whole DayPut back exactly the rows a change touched. Everything written since stays where it is.
- Dry-Run FirstAn undo is checked before it runs. A row someone changed since is skipped and listed, never overwritten.
- Your Rules, per DatabaseSave every change or only deletes, pick when a full restore point is taken, and what happens when rows can't be saved.

Works with your agent
Give Your Agent the Whole Toolbox
Claude Code, Codex, Cursor and OpenCode get TableStudio's tools and checks on every database you've connected. TableStudio sets up the plugin when it first opens.
55+MCP toolsFrom the schema to a staged migration
78Query rules20 catch wrong answers, not just slow ones
96Health checksBloat, locks, wraparound, replication lag
67Schema checksFixes come with their rollback SQL
8EnginesOne plugin for all of them
Download for macOS
7-day free trial · No credit card · Then $49 once, no subscription
Or install TableStudio and the plugin from the terminal:
$
curl -fsSL https://tablestudio.sh/install | bashFeatures
And Everything Else, in the Same App
Local servers, sandboxes, migrations between platforms, sync, tunnels and more. All included, nothing extra to install.
Local Servers
Postgres, MySQL, ClickHouse and CockroachDB servers on your Mac, started and stopped from TableStudio. The ones Homebrew and Postgres.app set up are picked up, data untouched.
Sandboxes
A throwaway local copy of any database in one step, on the same engine, with its real rows or none. Try the risky migration there first, or hand it to your agent.
Move Between Hosts and Engines
From the cloud to your Mac, one host to another, or Postgres to MySQL. A pre-flight report flags what won't translate before anything is copied.
Data Sync
Make one database's rows match another's. Only the differences are written, parents before children, then it checks the two really match.
Tunnels
Put a local server online through a Cloudflare Tunnel and send a teammate the connect command. Switch it off and it's gone.
Backups & Restore Points
Back up in each engine's own format to your Mac or any S3 bucket, and snapshot a whole database before a risky change. D1 and ClickHouse Cloud included.
Index Advisor
The fewest indexes that cover the most database time, from your real workload, proven against the planner before one is built. Postgres.
Drop an Index Safely
Hide an "unused" index from the planner and see which queries would get slower before you drop it. Postgres.
Schema Compare to Script
Compare dev with production and get the migration script that closes the gap, written for the target's engine.
Migration Watcher
Watches your Drizzle or Prisma migrations folder and tells you what's pending, failed or drifted, with the SQL right there.
Workflows
Chain backups, health checks, exports and SQL into one saved run, like a backup that restores itself into a sandbox to prove it works.
Your Host's Tools, Built In
Link your database host's account and its own tools, from branches to logs, work next to TableStudio's. Anything irreversible still asks you first.
Pricing
One Payment. Lifetime Activation.
No monthly subscription. No annual renewal. Pay once, own it forever - every future update included.
Free Trial
7-day trialTry the full app free for 7 days.
Free
- Every feature unlocked
- No credit card
- No account needed
Lifetime
Pay once, keep it forever.
$49
one-time payment
- Every feature, no add-ons
- 1 Mac per license
- Every database engine
- Free updates for life
- Unlimited connections
Team
Lifetime licenses for your whole team.
$44
per seat - one-time
- Everything in Lifetime
- A license key per teammate
- Assign seats by email
- One invoice, paid once
$220 total, paid once
Add 5 more seats for $40 per seat
No subscription. No renewal.
FAQ
Common questions
Everything you need to know before you download.
Agents
Claude Code, Codex, Cursor and OpenCode get the TableStudio plugin, which TableStudio sets up the first time it opens. Claude Desktop, VS Code, Windsurf, Zed, Gemini CLI, Raycast and any other MCP client connect to TableStudio's MCP server directly, with a ready-made snippet for each in Settings → MCP.
Over 55 tools on every database you've connected: read the whole schema in one call, run queries, dry-run a write against the real rows, try a migration on a throwaway sandbox, run health and schema checks, and find the indexes a slow query needs. A change to production goes to your review instead of the database.
No. TableStudio is a full native Mac database client on its own: browse and edit tables, write SQL with schema-aware autocomplete, explore the schema, build dashboards, and back up, restore or move databases. The agent side is there when you want it.
Yes, with the model you choose: sign in with your ChatGPT or GitHub Copilot account, add an API key for OpenAI, Anthropic, Google Gemini, OpenRouter, Mistral and others, or run a local model through Ollama, LM Studio or llama.cpp. Any OpenAI-compatible endpoint works too.
No. The plugin is free and its source is on GitHub. It needs TableStudio running on your Mac: 7 days free with every feature, then $49 once.
Those connect an agent to a database through a connection string in its config, and the safety they offer is mostly a read-only switch. TableStudio reaches every connection you've saved by name, with no password in any config file, and lets agents do real work without a free hand: production changes wait for your review, writes can be dry-run against the real rows, every AI change can be undone, and the Agent Center records every call. It's also a full database client for when you want to look yourself.
Safety and privacy
TableStudio enforces its rules itself, whatever the agent, its prompt or its auto-approve setting does: reads are read-only in the database, production only changes through your review, and functions with side effects are refused. For the strongest guarantee, also give agents a database role without write privileges on production.
Undo it. Before an agent changes a row, TableStudio saves the rows it's about to touch, on every engine, and you can undo that one change from the Agent Center without restoring the whole database. Schema changes save the schema first.
Yes. The Agent Center shows every conversation from every agent: each call it made, what it read, dry-ran, proposed and changed, and what TableStudio stopped and why. Changes waiting for your review are there too.
No. Agents reach your saved connections by name through TableStudio. Passwords stay in your Keychain, and the plugin reads TableStudio's MCP token from the app, so there's no secret in any config file.
No. Your agent talks to TableStudio on localhost, and TableStudio talks to your database directly. What the Agent Center records stays in TableStudio's own files on your Mac, for 30 days. Rows your agent reads do go to its model provider as part of the chat: set a database to Structure only to keep row values out, or Off to hide it completely.
Databases and your Mac
PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, ClickHouse, CockroachDB and Cloudflare D1, directly, over an SSH tunnel, or through platforms like Supabase, Neon, PlanetScale and RDS. The index advisor, index what-ifs and query benchmarks are PostgreSQL-only; the agent tools, health checks and undo work on every engine.
Yes. Start and stop local Postgres, MySQL, ClickHouse and CockroachDB servers from TableStudio, and the ones Homebrew and Postgres.app set up are picked up with their data untouched. A sandbox gives you, or your agent, a throwaway local copy of any database in one step.
A Mac with macOS 15 Sequoia or later, Apple Silicon or Intel. TableStudio is a native Mac app; there's no Windows or Linux version.
Like TablePlus and Postico, TableStudio is a native Mac app, not a Java or Electron one like DBeaver or Beekeeper Studio. Unlike Postico, which is PostgreSQL-only, it covers eight engines. On top of browsing, editing and SQL, it runs local database servers, makes throwaway sandboxes, checks health, schema and queries, and gives coding agents a safe way in with undo for every AI change. It's $49 once, with no subscription.
Pricing and licenses
Yes. Download TableStudio and you get 7 full days with every feature unlocked, including every engine, the plugin and the AI chat. No credit card, no account.
$49, once. A Lifetime license gets you every feature, every engine, unlimited connections and free updates for life. There's no subscription and nothing to renew.
Yes, for students and indie developers. Email [email protected] with a line about what you're working on, from your school address if you have one, and we'll send you a discount code.
A license activates TableStudio on one Mac. Moving to a new one? Open Settings › License on the old Mac, choose Deactivate this device, then activate it on the new one.
Yes. Buy a pack of seats and pay once: the more seats, the less each one costs. You assign seats to teammates by email, and each person gets their own license key.
Let Your Agent Near the Database Tonight
7 days, every feature, nothing to sign up for. Install the app, let it set up your agent, and ask about your data. Then keep it for $49, once.