CroDB: MySQL & PostgreSQL

Native, fast, safe SQL client

Only for Mac

$1.99

Mac

2.1 adds an MCP server, so AI agents can reach your databases under per-connection access levels and your approval — and rebuilds SQL autocomplete. CroDB is a native macOS client for MySQL and PostgreSQL. It opens instantly, stays out of your way, and takes production seriously: every write is checked before it reaches the server, and nothing about your databases leaves your Mac. CONNECT THE WAY YOU ALREADY DO • MySQL 5.7 and 8.x, PostgreSQL 14 through 18 • TCP/IP or Unix socket, with TLS modes for both engines, from disabled up to full certificate and host-name verification • SSH tunnels with password or private-key authentication; local ports are chosen automatically • Passwords and SSH secrets are kept in the macOS Keychain, never in plain-text files • Paste a mysql:// or postgresql:// URL to fill in a connection, or copy one out • Folders, color tags and environment labels (Local, Development, Testing, Staging, Production) keep dozens of servers organized • Read-only connections refuse writes on the client before anything is sent BROWSE AND SEARCH • Databases, schemas, tables, views, materialized views, procedures, functions, triggers, events and sequences in one sidebar • Quick Query (⌘K) jumps to any connection, table, saved query or command • One-click actions: open data, design table, query the first 100 rows, show DDL, generate SQL WORK WITH DATA LIKE A SPREADSHEET • Paged grid with filter conditions, sorting, row counts and remembered column layouts • Edit cells inline or in a dedicated editor for text, JSON, hex and images, with an explicit SQL NULL switch • Add and delete rows, paste blocks of cells from the clipboard, undo edits before they are applied • Review the exact INSERT, UPDATE and DELETE statements before they are committed • Copy selections as tab-separated text, CSV, JSON, Markdown or INSERT statements • Find in results with ⌘F A SQL EDITOR THAT KEEPS ITS SESSION • Syntax highlighting, autocomplete, formatting (⌥⌘L), line numbers and comment toggling • Run the current statement, the selection or everything; stop long queries with ⌘. • Every tab keeps its own server session, so BEGIN, SET, temporary tables and session variables persist between runs • Begin, Commit and Rollback controls with live transaction state • Multiple result sets, a Messages panel for warnings and notices, and EXPLAIN • Query history, favorite queries and drafts that come back after a restart DESIGN TABLES WITHOUT WRITING DDL • Fields, indexes, foreign keys, check constraints, triggers and table options in one designer • Create tables, rename them and change column types, with USING casts on PostgreSQL • Every change is shown as the statements it will run before you save IMPORT AND EXPORT AT ANY SIZE • Export the displayed rows or every row as CSV, TSV, JSON, SQL INSERT or Markdown; whole-table exports stream from the server • Import CSV with encoding detection, field mapping, batch sizes and conflict handling: ignore, update or replace on MySQL, ON CONFLICT on PostgreSQL • Choose to stop and roll back on the first error, or skip failed batches and see which rows they held • Transfers run in the background with progress and cancel BUILT FOR PRODUCTION • Dangerous SQL detection: UPDATE or DELETE without WHERE, DROP, TRUNCATE, ALTER … DROP, SET GLOBAL, SELECT INTO OUTFILE, and writes hidden inside WITH clauses or subqueries • The confirmation sheet shows the statement, the connection, the database and the environment; on production you type the database name to proceed • Maximum affected-row limits roll back changes that go too far • Production connections always use delayed commit • Warnings before closing a tab, a window or the app while transactions are open or transfers are running PRIVATE BY DESIGN • No account, no sign-in, no analytics, no ads • Connection profiles, history and drafts are stored only on your Mac • Sandboxed, and reads only the files you choose Also: multiple windows (⇧⌘N) with window and tab restoration, light and dark appearance, and an interface in English, Simplified Chinese and Portuguese. Requires macOS 15 or later.

  • This app hasn’t received enough ratings or reviews to display an overview.

CroDB 2.1 adds an MCP server and rebuilds SQL autocomplete. MCP SERVER • Connect an AI agent to the databases you already have open in CroDB. Configuration snippets for Claude Code, Claude Desktop and Codex are generated for you, carrying the right port and token • Off until you turn it on. It listens on loopback only and every request needs a bearer token • Access is granted per connection: No Access, Read-only, or Read & Write. Nothing is shared by default • Writes wait for you to approve them, statement by statement; production connections make you type the database name first • An activity list in Settings shows every call an agent made, including the ones CroDB refused and why • Tools for browsing schemas, reading tables, running and explaining queries, and driving transactions — an agent can also open a query or a table in a tab for you to look at • Row, cell, payload and timeout limits you set yourself SQL AUTOCOMPLETE • Suggestions appear as you type, from the first character, instead of only when you press a shortcut • Tables, views, columns and routines come from the database that tab is pointed at, and from nothing else • Column completion follows aliases: after FROM users u, typing u. lists that table's columns in table order, with their types • Suggestions are ranked for where the caret is — FROM after a select list, WHERE and JOIN once a table is named, columns inside a WHERE, types in a column definition • The schema loads on its own; you no longer have to expand the sidebar before completion knows your tables • Control-Space completes on demand, and typing never rewrites your SQL until you accept a suggestion • Names match on any word or on initials, so cn finds customer_name • Keywords, functions and types for MySQL, PostgreSQL and SQLite

The developer, 健 陆, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Not Collected

    The developer does not collect any data from this app.

    Privacy practices may vary, for example, based on the features you use or your age. Learn More

    The developer has not yet indicated which accessibility features this app supports. Learn More

    Seller
    健 陆
    Size
    11.7 MB
    Category
    Developer Tools
    Compatibility
    Requires macOS 15.0 or later.
    • Mac
      Requires macOS 15.0 or later.
    Languages
    English and 9 more
    • English, French, German, Italian, Japanese, Korean, Portuguese, Simplified Chinese, Spanish, Traditional Chinese
    Age Rating
    4+
    Copyright
    © 2026 CroWall