Halfnine — Claude Code MCP server for PostgreSQL
This MCP server for Claude Code gives an agent access to PostgreSQL connections in Halfnine. It can read data and prepare changes for approval in the app.
no license ★ 1 updated 2026-11-01
Open on GitHubWhat Halfnine does
Halfnine exposes PostgreSQL connections from its desktop app to an AI agent. Permissions are set per connection: Off, Read, Read with approved writes, or Full. Connections marked red start in Off; other connections start in Read.
With Read with approved writes, proposed changes appear in Halfnine as SQL or staged rows and wait for approval. The Agents page lists agent activity and has a switch to pause all agents. Data the agent reads is sent to its AI provider.
To connect a tool, open Agents and select Connect beside it. Halfnine displays the settings changes before adding the tool.
What it helps with
- read PostgreSQL data through an agent
- prepare SQL changes for approval in the app
- set agent permissions for each connection
- pause all connected agents
Example prompts for the agent
- Read the PostgreSQL tables in this connection and summarize their contents.
- Prepare SQL to change this schema and leave the changes for approval in Halfnine.
- Show me what data is available through this PostgreSQL connection.
How to install Halfnine
Install
The MCP registry has no launch command for it: see the repository README
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Halfnine
How do I install Halfnine in Claude Code?
Install the Halfnine app, open Agents, then select Connect beside Claude Code. Halfnine shows the settings changes before connecting the tool.
What does Halfnine do?
It gives an agent access to PostgreSQL connections with configurable permissions. In Read with approved writes mode, changes wait for approval in the app.
What permissions can Halfnine grant an agent?
Each connection offers Off, Read, Read with approved writes, and Full. Red-labelled connections start in Off; other connections start in Read.