The First Database Client You'll Enjoy Opening

Native macOS, every engine in one window. It knows your schema, finds your missing indexes, and your AI tools connect straight in.

Download for macOS

Hero Demo Video

VIDEO (60–90s): Full product walkthrough. Open TableStudio, connect to a Postgres, MySQL or ClickHouse database, run a query with AI chat, view schema insights with index suggestions, open the ER diagram, show the MCP server config, and end on the command palette. Dark theme. Add captions for key features as they appear.

Integrations

Connects to everything you already use

Every modern relational engine and the platforms built on them, in one native app. One lifetime activation covers all of them - no per-connector upsell, no driver to hunt down.

PostgreSQL

MySQL

SQLite

ClickHouse

Supabase

PostgreSQL

MySQL

SQLite

ClickHouse

Supabase

PostgreSQL

MySQL

SQLite

ClickHouse

Supabase

PostgreSQL

MySQL

SQLite

ClickHouse

Supabase

PostgreSQL

MySQL

SQLite

ClickHouse

Supabase

PostgreSQL

MySQL

SQLite

ClickHouse

Supabase

Neon

PlanetScale

Cloudflare

Raycast

Apple Spotlight

Neon

PlanetScale

Cloudflare

Raycast

Apple Spotlight

Neon

PlanetScale

Cloudflare

Raycast

Apple Spotlight

Neon

PlanetScale

Cloudflare

Raycast

Apple Spotlight

Neon

PlanetScale

Cloudflare

Raycast

Apple Spotlight

Neon

PlanetScale

Cloudflare

Raycast

Apple Spotlight

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 Chat
Ask 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 Browse
Find 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 Model
Already 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, Earned
Based on your real query patterns - not heuristics. Estimated speedup shown before you apply. One click to review, one click to run.
ER Diagrams, Always Current
Generated from your live schema, not a static export from six months ago. Always reflects what you actually have.
Schema Diffs That Matter
Compare dev vs staging vs production side by side. Spot drift before it becomes an incident.

TableStudio schema insights panel with suggested indexes, an ER diagram preview, and a database hygiene score

Prove the Rewrite Is Faster - and Returns the Same Rows

The Query Optimizer starts from the statements your Postgres server actually spends its time on, explains what's wrong with each one, and shows what the planner says would fix it. Then Query Lab measures your baseline against every alternative on the same numbers.

Medians, Not Lucky Runs
Every runtime is the median of several executions. One run mostly measures cache state - Query Lab won't let a fluke convince you a rewrite helped.
Same Rows, Checked
Each variant is checksummed against the baseline. A faster query that returns different results is a wrong answer, and you'll see it before you ship it.
Test Indexes That Don't Exist Yet
With hypopg, try a hypothetical index as a variant and see the planner's cost - nothing built, nothing locked, nothing to clean up.

IMAGE - Query Lab: a baseline query and two variants (an AI rewrite and a hypothetical index) side by side, with median runtime, planner cost, and a matching checksum column. Dark theme.

Stop Pasting Your Schema Into Every Chat Window

TableStudio runs a local MCP server so Cursor, Claude, and Copilot get live access to your database - not a snapshot from last week. Every action they take is logged, tagged with the tool that triggered it.

Local MCP Server, Always Running
No config, no cloud relay. Your AI tools connect directly to TableStudio, TableStudio connects to your database.
Full Read, Write & Migrations
Not read-only. Your AI coding tools can do everything you can - with every action logged in the audit trail.
Complete Audit Trail
Every query tagged with the tool that triggered it. When Claude runs a migration, you'll know - timestamp, duration, full SQL.

You Approve What Hits Your Database

AI agents are fast. Sometimes too fast. TableStudio intercepts destructive MCP operations - writes, deletes, migrations - and surfaces them as native macOS notifications before anything runs. Approve, ignore, or edit the SQL yourself. Your database, your call.

Staging & Approval Flow
Writes, deletes, and schema changes from AI tools are held for review. Nothing destructive runs without your sign-off.
Native macOS Notifications
Review and act on pending operations right from your notification center - no need to switch windows mid-flow.
Approve, Edit, or Ignore
Approve the operation as-is, edit the SQL before it runs, or dismiss it entirely. Full control, zero friction.

IMAGE - macOS notification appearing over the TableStudio app: 'Claude wants to DELETE 847 rows from orders - staged for review'. Below it, a modal inside TableStudio showing the full SQL with three buttons: 'Approve', 'Edit', 'Ignore'. Dark theme, native macOS notification style.

Break Things in a Sandbox, Not in Production

Spin up a throwaway copy of any connection in one step. Sandboxes are always local - a fresh SQLite file or a brand-new local Postgres or MySQL instance - so experiments, risky migrations, and AI agents never touch the real server.

Real Data, Fake Data, or Empty
Seed the sandbox with a copy of your data, foreign-key-aware generated rows, or just the schema. Your call per sandbox.
Point Any Tool At It
Every sandbox shows its connection string, so your app, tests, or AI coding tools can use it like any other database.
Gone in One Click
Done experimenting? Discard the sandbox and its local server with it. No leftover containers, no stray databases.

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 Commands
The palette adapts to what you have open. In the query editor? You get query actions. In the schema browser? Schema actions.
Everything, Instantly
Connect 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 Everything
TableStudio, connections, recent queries, migrations - all searchable from one place. No hunting through menus.

A Dashboard That Actually Knows Your Database

Not generic server stats - widgets generated from your live schema. TableStudio ships with a default widget set, an AI that suggests what to track based on your actual tables, and a builder to create your own with SQL or plain English.

Widget Marketplace
Default widgets for DB health, query performance, and slow query trends. Browse and install community widgets in one click - or build your own.
AI-Generated Widgets
TableStudio reads your schema and suggests widgets that make sense for your data. "Track orders by status" or "watch your users table growth" - proposed automatically, added in one click.
Build With SQL or Plain English
Write a SQL query and turn it into a widget. Or describe what you want to see and let the AI write the query. Either way, it's on your dashboard in seconds.

TableStudio dashboard with database health, slow query, and custom SQL widgets

Features

Every Feature, One App

Here's everything TableStudio does beyond the query editor - backups, migrations, import and export, schema diffs, an audit log and more. All included, nothing extra to install.

Dashboard

Schema-aware widgets, AI suggestions, and a SQL builder. The dashboard you'd build yourself if you had time - already built.

Audit Log

Every query. Who ran it, when, how long, full SQL. Includes queries from your AI coding tools. Compliance teams stop asking questions.

Import / Export

CSV, JSON, SQL dumps and native engine dumps - without leaving the app. One dialect-aware exporter for every engine - no psql, mysqldump, or StackOverflow tab required.

Backup & Restore

Scheduled backups, on-demand snapshots, one-click restore. So the 3am "can we roll this back" is a non-event.

DB Migrations

TableStudio watches your Drizzle or Prisma migrations folder and tells you what's pending or failed, with the SQL right there. Apply it through your project's own CLI, without leaving the app.

DB Hygiene

Table bloat, dead tuples, unused indexes, long-running queries - engine-aware checks for whichever database you're on, flagged automatically. Your future self will thank you.

Workflows

Chain backups, health checks, exports and SQL into one saved run. Start from a preset - like a backup that restores itself into a sandbox to prove it works - and run it from the menu bar.

Local Databases

Run Postgres, MySQL and ClickHouse servers on your Mac, straight from TableStudio. Start, stop, create databases - and import the ones Homebrew or Postgres.app already set up.

Cross-Engine Migration

Move a database to another server, or to another engine entirely. A pre-flight report flags what won't translate, then the schema is converted and the data streamed across.

Schema Comparer

Dev diverged from staging again. TableStudio shows you exactly where and when. One panel, full diff, actionable.

ER Diagram

Live ER diagrams from your actual schema. Not a static export from six months ago. The real thing, always.

Multiple Connections

Postgres, MySQL, SQLite, ClickHouse, Supabase, Neon, PlanetScale, RDS - all in one sidebar. Switch engines like you switch browser tabs.

Pricing

One Payment. Lifetime Activation.

No monthly subscription. No annual renewal. No seat count. Pay once, own it forever - every future update included.

Free Trial

14-day trial

Try every feature free for 14 days. No credit card. No account. No catch.

Free

14 full days - all features
No credit card required
No account needed
MCP server
AI chat & search

Download for macOS

TableStudio Lifetime

One payment, one lifetime activation. Every feature, every future update - never a monthly bill.

$99

one-time - lifetime activation

Lifetime activation - pay once
Zero subscription, zero renewals
All future updates included
MCP server
AI chat & schema insights
DB hygiene & audit log
Unlimited connections

No subscription. No renewal.

Download

Try TableStudio Free for 14 Days

Native macOS app. Every engine, every feature. No account. No credit card. All unlocked from day one.

Download for macOS

macOS 12 Monterey or later · Apple Silicon & Intel · $99 one-time, lifetime activation after trial · no subscription

Loved by database developers

Devs who've tried TableStudio don't go back

From indie hackers to engineering leads - here's what they actually said.

I'd been on DataGrip for four years. Switched on the trial and genuinely couldn't go back. The AI knows my schema - it doesn't hallucinate column names.

Alex Rivera

Backend Engineer

The MCP server is the killer feature nobody's talking about. Pointed Cursor at it and it ran a migration I'd been putting off for a week. Audit log showed exactly what it did.

Priya Nair

Staff Engineer

Index suggestions caught two missing indexes costing us 3× on our most critical query. The $79 paid for itself in the first hour.

James O'Brien

CTO, Series A startup

The schema comparer is what got me. Three environments drifting apart for months and we didn't know it. TableStudio made it visible in about 30 seconds.

Maya Chen

Platform Lead

Dead tuples, zombie sequences, unused indexes - TableStudio found things I didn't know to look for. My schema is the cleanest it's ever been.

Tobias Müller

Senior DBA

The approval flow for MCP operations is genius. Claude staged a DELETE on 2,000 rows and I caught a bad WHERE clause before it ran.

Sofia Park

Indie Hacker & SaaS builder

No subscription. No seat count. No "this feature is Pro only". $79 and it's all there. That alone made me buy it.

Marcus Thompson

Full-Stack Developer

I had TablePlus for Postgres, Sequel Ace for MySQL and a terminal for ClickHouse. TableStudio replaced all three, and the AI is better than any of them.

Lin Wei

Lead Developer

No credit card on the trial is rare. Tried it, bought it within 2 days. Easiest $79 I've spent this year.

Rachel Kim

Senior Backend Engineer

FAQ

Common questions

Everything you need to know before you download.

Your current database client will feel broken by comparison.

Native macOS. 14-day free trial. No credit card, no account, no onboarding survey. Download, connect your database, and see what you've been missing.

Download for macOS View Pricing