Skip to main content
MCP server CX Codex

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 GitHub

What 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.

Similar MCP servers

All MCP servers for Data and databases →

Project sponsors

Companies that keep this analytics open