The native database IDE
powered by AI
Query PostgreSQL, MySQL, SQLite, Redis, MongoDB, and SQL Server from one fast, native app on macOS and Windows. Built-in AI chat with Claude, GPT, or local Ollama. MCP server and team tools in Pro.
Connect to all your databases
Native drivers for every engine you actually use — no ODBC, no JDBC, no Electron middle layer.
More engines on the roadmap — ClickHouse, Cassandra, DynamoDB coming next.
Everything you need, nothing you don't
The full Gridex experience for solo developers: six databases, AI chat, MCP server, and a native editor that feels instant. Every feature below ships in the free build — no trials, no paywalls.
AI Chat Built-in
Ask in plain English or Vietnamese. Gridex writes the SQL, runs it, and explains the result. Works with Claude, GPT, and local Ollama — your choice of model, your API key.
Auto Schema Diagram
Zoomable ERD generated from live schema. Shows tables, columns, and foreign keys. Export as PNG or SVG for docs and reviews.
Query Editor
Multi-tab editor with autocomplete for schemas, tables, and columns. Syntax highlighting, inline errors, full query history, and one-click export to CSV, JSON, or SQL.
Table Editor
Edit rows like a spreadsheet. Inline cell editing, filtering, sorting, bulk updates, and a dedicated JSON document editor for MongoDB. Every change previewed before it writes.
SSH Tunnel
Reach production databases behind a bastion in seconds. Password or private-key auth, jump-host chains, and all credentials stored in the macOS Keychain or Windows Credential Manager — never on disk.
Import & Export
Import CSV, JSON, or SQL dumps with column mapping and type detection. Export any query result or full table. One-click backup and restore per connection.
Built for teams running real databases
Enterprise-grade observability, automation, intelligence, and safety — without leaving the IDE or writing a line of ops code.
Realtime Connection Monitor
Live view of every active and idle connection, who holds which lock, what query is running, and how long it's been waiting. Catch leaks and contention before they page you.
Slow Query & Threat Log
Automatic tracking of slow queries, N+1 patterns, failed statements, and suspicious shapes that look like SQL injection. Filter, compare, and export for your on-call review.
Scheduled Jobs & Cron
Run queries, exports, health checks, and maintenance on a schedule. Chain steps, branch on results, and alert your team on failure.
Cross-Database Sync
Copy tables, queries, or whole schemas between any two connections — Postgres to MySQL, Mongo to Postgres, prod to staging. Preview the diff before it runs.
AI Mock Data Generator
Describe the rows you need. AI generates realistic, constraint-aware mock data that respects your schema, foreign keys, and enums. Seed thousands of rows in seconds.
MCP Server
Expose any connection as a standard MCP endpoint. Claude Desktop, Cursor, and any MCP-compatible agent can query your database safely — with read-only mode, per-table scopes, and an audit trail of every tool call.
Visual Query Builder
Drag tables and columns onto a canvas. Pick joins, filters, and aggregations. Review the generated SQL before it runs — no typing required.
Row Relationship Graph
Right-click any row to expand its entire graph. One click on an order reveals the user, the products, and every related record — visualized as a diagram, not a wall of JOINs.
Named Checkpoints
Backup and restore, evolved. Create titled snapshots before risky migrations, label them, compare them, and roll forward or back from one panel.
SQL Injection Detection
Static and runtime inspection of every query shape hitting your databases. Flag risky patterns, unsanitized inputs, and anomalous call sites before they become a breach.
Audit Log & Team RBAC
Every query, export, and connection attempt logged by user. Role-based permissions per database and per table. Compliance-ready trails for SOC 2 and internal review.
Why choose Gridex?
The only database IDE that ships AI, MCP, and team-grade tooling in one native app.
| Feature | Gridex | TablePlus | DBeaver |
|---|---|---|---|
| Native app (no Electron) | Java | ||
| macOS & Windows | |||
| AI Chat | |||
| Local AI (Ollama) | |||
| Multi-DB | |||
| Free tier | Limited | ||
| MCP Server | Pro | ||
| Realtime Connection Monitor | Pro | Limited | |
| Slow Query & Threat Log | Pro | ||
| Row Relationship Graph | Pro | ||
| Visual Query Builder | Pro | ||
| Scheduled Jobs & Cron | Pro | ||
| Cross-Database Sync | Pro | Limited | |
| AI Mock Data Generator | Pro | ||
| Named Checkpoints | Pro | ||
| Audit Log & Team RBAC | Pro |
Data last reviewed 2026 — competitors' features based on publicly documented releases.
Common questions about Gridex
Everything you need to know about the AI-native database IDE, the databases it supports, and how Pro works.
What is Gridex?
Gridex is a native database IDE for macOS and Windows with built-in AI chat and an MCP (Model Context Protocol) server. It lets you query PostgreSQL, MySQL, SQLite, Redis, MongoDB, and SQL Server in one fast, native app — and describe what you need in plain language to let AI write the SQL for you.
Is Gridex free?
Yes. The Gridex Community edition is free forever, with no account required and no usage limits. AI chat, multi-database connections, the query editor, SSH tunneling, and import/export are all included. A paid Pro tier is available for teams that need MCP server, team RBAC, audit logs, and enterprise-grade automation.
Which databases does Gridex support?
Gridex supports PostgreSQL, MySQL, SQLite, Redis, MongoDB, and SQL Server today. More drivers are on the way. You can open multiple connections of different types side-by-side in the same window.
Does Gridex work with Claude, GPT, and Ollama?
Yes. You can connect Gridex to Anthropic Claude, OpenAI GPT, or a local Ollama instance using your own API key. Gridex never proxies prompts through its own servers — requests go directly from your machine to the model you configure, on both macOS and Windows.
What is the MCP server in Gridex?
MCP (Model Context Protocol) is the open standard that lets external AI agents — such as Claude Desktop, Cursor, and MCP-compatible IDEs — call tools safely. Gridex Pro exposes any database connection as an MCP endpoint with read-only mode, per-table scopes, and a full audit trail, so AI agents can query your data without ever seeing raw credentials.
Is Gridex a TablePlus or DBeaver alternative?
Yes. Gridex is designed as a modern alternative to TablePlus, DBeaver, DataGrip, Beekeeper Studio, and HeidiSQL. Unlike most of them, Gridex is built natively on each platform — Swift/AppKit on macOS, native code on Windows — not Electron or Java. It ships AI chat and MCP out of the box and supports local AI via Ollama for privacy-sensitive workflows.
Is my data and my credentials secure?
Database credentials are stored in the macOS Keychain on Mac and the Windows Credential Manager on Windows — never in plain text on disk. SSH tunnels support password and private-key authentication with jump-host chains. The Community edition works fully offline; Pro features like the audit log and MCP server run locally unless you explicitly invite teammates.
Does Gridex support SSH tunneling and production databases?
Yes. Gridex has first-class SSH tunnel support with password or private-key authentication, multi-hop jump hosts, and Keychain-backed credential storage, so you can connect to production databases behind a bastion in seconds.
Is Gridex available for Windows and Linux?
Gridex ships first-class native builds for both macOS (Apple Silicon and Intel) and Windows 10 / 11 (64-bit). Both platforms get the same feature set — AI chat, multi-database connections, SSH tunneling, and the full query and table editors. Linux support is on the roadmap.
How do I get Gridex Pro?
Pro is currently in early access. You can request access from the Pro section of this page, and we'll reach out when your seat is ready.
Still have questions? Email us →
Ready to try Gridex?
Free to download. No account required.
Available for macOS and Windows.