whereismyai
pgMagic
pgMagic is a PostgreSQL client for macOS that translates natural language questions into executable SQL queries.
pgMagic is a lightweight desktop application that connects directly to PostgreSQL databases. Users enter natural language questions, which the application converts into SQL based on the database schema. The tool includes standard database client features such as a schema viewer, a table viewer capable of rendering thousands of rows, and SQL syntax highlighting. It functions as a client-only application, requiring users to input their own OpenAI API key to process natural language queries. The application transmits the public schema and user queries to OpenAI, but does not send row data. It stores database credentials locally on the user's machine.
pgMagic at a glance
- Best for: Software engineer, Finance
- Runs on: macOS
- Pricing: One-time purchase price; requires user-provided OpenAI API key
- Released: June 2023
- Category: AI coding tool
- Website: pgmagic.app
Key features
- Natural language to SQL query generation
- Direct connection to PostgreSQL instances
- SQL syntax highlighting and autocomplete
- Schema and table viewer
- Export of results to JSON
- Storage of credentials locally
- Multi-database management
Use it for
- Querying PostgreSQL databases using plain English
- Managing multiple PostgreSQL database connections
- Viewing and browsing large datasets
- Exporting query results
Alternatives to pgMagic
- pgbot — It gives you plain-English answers and explanations instead of complex database dashboards.
- Frizky Kramer — Integrates with existing Claude Code, Codex, or Cursor installations.
- Tabula — It combines local AI capabilities with a keyboard-first native database interface.
- QueryDeck — Auto-detects your ORM and runs directly on macOS with zero subscription fees.
- AI2sql — Connects directly to live database schemas to generate accurate, dialect-specific SQL.
- Postgres MCP Pro — It provides AI agents with deep database analysis and safe query execution tools.
- Postquel — Uses your existing local Claude Code, Codex, or Cursor AI account.
- TEXT2SQL.AI — Generates accurate SQL queries from natural language instantly.
- DBJoy — Ask questions in plain language and run safe queries with your own API key.
- pgEdge — It combines AI tooling with standard Postgres and flexible deployment options.
- TablePro — Native frameworks, multi-database support, and open source.
- Tabularis — Combines a full-featured human SQL editor with a built-in Model Context Protocol server.
All pgMagic alternatives