Postquel: a native PostgreSQL client for Mac, with your own AI

说明与用途

Postquel 是一款 macOS 原生 PostgreSQL 客户端，使用已有 AI 账户集成 AI，无需单独 API 密钥，支持表浏览、编辑和自然语言生成 SQL。

问题

Database developers need a lightweight, native macOS client that integrates AI assistance without requiring separate API keys.

结果

Postquel enables developers to browse and edit PostgreSQL databases natively on macOS while leveraging existing AI accounts for read‑only data queries and SQL generation, eliminating the need for separate API keys and simplifying workflow.

工作流

• Launch Postquel and connect to a PostgreSQL database via libpq.
• Browse tables in the sidebar and open a table to view Content, Structure, or DDL.
• Edit rows directly in the grid or follow foreign keys to related tables.
• Use Cmd+Return to run a single query in a file, or save queries to the sidebar.
• Edit schema changes (columns, indexes, constraints) and preview generated SQL before applying in a single transaction.
• Open the assistant panel and sign in to an existing AI service (Claude Code, Codex, or Cursor Agent).
• Ask natural language questions about data (e.g., "Which customers spent the most last month?") and receive SQL queries and results in the chat window.
• Use the prompt bar to convert natural language descriptions into SQL queries.
• Review any proposed schema or data changes suggested by the assistant before executing them.
• Use SSH tunnels for remote connections and store passwords in Keychain.
• Run the app on macOS 15+ on Apple silicon or Intel; no local Postgres installation required.

证据

If you're signed in to Claude Code, Codex or Cursor Agent, Postquel can use that. You pick the agent and model. There's no separate API key to put into the app.

来源

The assistant has tools for reading the schema and querying your connected database. It can look up the tables itself. You don't have to copy a bunch of table definitions into a chat window first.

来源

The assistant's database connection is read-only. If it wants to change data or the schema, it proposes SQL for you to review, dry-run and apply.

来源