{"appstoreID":6829200445,"title":"Gadwal - Postgres MySQL Client","subtitle":"SQL Database GUI with AI & MCP","developerName":"Ibrahim elsherbini","description":"Edit your database like a spreadsheet, and let your AI apps help without handing them the keys. Gadwal is a native Mac client for Postgres, MySQL, MariaDB, SQLite, DuckDB, Cloudflare D1, ClickHouse and BigQuery. Change cells, review the exact SQL, press ⌘S. Nothing is written until you do.\n\nIts built-in MCP server lets the AI apps you already use (Claude Desktop, Claude Code, Codex, Cursor, VS Code) read your data and propose changes. Proposed changes don't run. They wait in a Review list with the exact SQL, and you approve or reject each one. No API keys to paste into Gadwal.\n\nTABLE EDITOR\n• Browse, filter and sort tables with millions of rows without loading them all into memory\n• Edit cells, insert and delete rows; every change is marked until you save\n• Review Changes shows the SQL that will run before you commit\n• Structure view for columns, indexes and foreign keys\n• Follow a foreign key to the row it points at\n• Export to CSV, JSON or SQL; import CSV\n\nSQL EDITOR\n• Syntax highlighting and completion for tables and columns\n• Query history and saved queries\n• Run one statement or the whole script; results open in the same grid\n• BigQuery queries show the bytes they will process before they run\n\nAI THAT ASKS FIRST\n• The MCP server is off until you turn it on, and it only listens on this Mac (127.0.0.1)\n• Set an AI level per connection: Off, Read-only, Ask before write, or Full\n• Production connections start as Read-only\n• Hide columns from AI, such as passwords and tokens; they're removed before results leave the app\n• Destructive changes (DROP, TRUNCATE, DELETE without WHERE) always need your approval and, where the engine supports it, take a backup first\n• Every AI request is logged, with the client, the SQL and what you decided\n• One-click setup for Claude Desktop, Cursor and VS Code; copy-ready commands for Claude Code and Codex\n\nSAFE FOR PRODUCTION\n• Color-coded environments (Local, Dev, Staging, Production) so you always know where you are\n• Safe mode asks before risky queries run on production connections\n\nBACKUP AND RESTORE\n• Back Up Now saves a connection to any folder you choose, including a folder in iCloud Drive\n• Each backup keeps every table's structure and rows, compressed, with a manifest of row counts and checksums\n• Restore the tables you pick; Gadwal backs them up first, so a restore can be undone\n• Works with every engine above except BigQuery, which keeps its own 7-day time travel\n\nWORDPRESS MODE\n• Detects WordPress tables, including custom prefixes and multisite\n• Reads and edits PHP-serialized values\n• Search & replace a domain across the database with a dry run first, so serialized data stays valid\n\nCONNECTIONS\n• SSH tunnels with password or key, TLS with your own CA certificate\n• Passwords and tokens are kept in your Mac's Keychain\n• Import saved connections from another database app or a .env file\n\nPRIVATE BY DESIGN\n• No account, no sign-in, no analytics, no telemetry\n• Gadwal talks only to the databases and cloud APIs you set up\n\nTRY IT FREE FOR 14 DAYS\nStart a 14-day free trial with every feature unlocked. After the trial, Gadwal keeps working with 2 saved connections, 2 tabs and 1 window. A one-time lifetime unlock removes those limits and turns on the AI tools and backups. No subscription.\n\nQuestions or a bug? Write to us from gadwal.dev/support.","bundleID":"com.dribrahimm.gadwal","appiconURL":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/e3/28/e8/e328e867-1850-a6fa-8c09-450280906a82/Placeholder.mill/1024x1024w.webp","bannerURL":null,"formattedPrice":"Free","appUpdated":"2026-11-18T19:09:43.000Z","appReleased":"2026-11-18T08:00:00.000Z","version":"1.0","platforms":["mac"],"minOS":{"mac":"Requires macOS 15.0 or later."},"topIAPs":[{"name":"Gadwal Lifetime","price":"$9.99"}],"languages":["EN"],"size":"37.5 MB","category":"Developer Tools","developerWebsite":"https://gadwal.dev/","screenshots":[{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/71/3b/99/713b9955-d5f6-767c-6440-95cdc0dd5696/01-edit-your-data-ai-asks-first.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/cd/de/54/cdde549b-e2c0-6a9e-75ff-524e18eba6f8/02-edit-tables-like-a-spreadsheet.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/58/8d/ad/588dad51-9969-b86b-2618-e8d485511351/03-ai-proposes-you-approve.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/1d/fe/9e/1dfe9ef4-e80a-1a8c-6651-200f50058c10/04-works-with-the-ai-you-use.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/3c/55/1a/3c551a62-3742-63b4-3ace-7fd91f83f336/05-you-decide-what-ai-sees.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/50/e2/29/50e229b1-feea-ba2d-a526-6f9b2eb64ea3/06-8-databases-one-native-app-logos.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/6e/87/82/6e878281-23ae-1d68-895b-bc5b0a1b3b22/07-write-sql-faster.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/b9/21/ba/b921bafc-54da-36be-92bd-df34ca286666/08-production-stays-protected.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/d1/40/41/d1404132-f8ab-0d47-3c37-fc191a268cb6/09-back-up-and-restore-anytime.png/2880x1800w.webp"},{"platform":"mac","url":"https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/cb/5f/e1/cb5fe118-c4c6-0fad-cfb0-d475a35da77b/10-move-wordpress-sites-safely.png/2880x1800w.webp"}]}