Advertise
MCP.so
Sign In

PgSQL MCP Server

@twn39

Repository

Basic information

Category

Other

Transports

stdio

Author

twn39

About PgSQL MCP Server

๐Ÿ”ง A powerful tool server based on the Model Context Protocol (MCP), enabling interaction with PostgreSQL databases via MCP calls.

#python#ai#mcp#postgresql#pgsql#mcp-server

PgSQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "pgsql-mcp-server-twn39": {
      "command": "uv",
      "args": [
        "tool",
        "install",
        "pgsql-mcp-server"
      ]
    }
  }
}

PgSQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is PgSQL MCP Server?

PgSQL MCP Server is a tool built on the Model Context Protocol (MCP) that enables interaction with PostgreSQL databases via MCP calls. It is designed for developers who need to query, manage, and explore PostgreSQL schemas and data through MCP-enabled clients.

How to use PgSQL MCP Server?

Install with uv tool install pgsql-mcp-server or pip install pgsql-mcp-server. Run using pgsql-mcp-server --dsn "postgresql://user:password@localhost:5432/db", or execute directly without installation via uvx pgsql-mcp-server --dsn "...".

Key features of PgSQL MCP Server

  • Asynchronous and efficient using asyncio and asyncpg.
  • Transactional safety with error handling and rollback.
  • Easy deployment via a simple command-line interface.
  • Provides DQL, DML, DDL, and DCL query execution tools.
  • Supports schema, table, column, index, and foreign key introspection.

Use cases of PgSQL MCP Server

  • Run SQL queries (SELECT, INSERT, UPDATE, DELETE) through MCP.
  • Execute transactional DDL and DCL operations via MCP calls.
  • Explore database metadata (schemas, tables, columns, indexes, foreign keys).
  • Debug and test MCP database interactions using the MCP Inspector.

Frequently asked questions

1

What Python version is required?

Python 3.10 or higher is required.

2

How do I install the server?

Install using `uv tool install pgsql-mcp-server` or `pip install pgsql-mcp-server`. You can also run directly with `uvx pgsql-mcp-server`.

3

What tools does the server provide?

It offers nine tools: get_schema_names, get_tables, get_columns, get_indexes, get_foreign_keys, run_dql_query, run_dml_query, run_ddl_query, and run_dcl_query.

4

How can I test or debug the server?

Use the MCP Inspector: run `npx @modelcontextprotocol/inspector uvx pgsql-mcp-server --dsn "..."` to visually inspect and test tools.

5

Are DDL and DML operations transactional?

Yes, DDL, DML, and DCL operations are executed within transactions with error handling and rollback mechanisms.

Comments

More Other MCP servers

Handl

Handl speaks the Model Context Protocol. Your whole billing operation โ€” projects, invoices, clients, reports, approvals โ€” as tools any AI assistant can call, inside your autonomy rules.

Glasswarp

Glasswarp

See and control a real Windows PC you own โ€” from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student โ€” in a fraction of the time. What once took a week, now takes one free period.

Advertise