Mcp Psycopg2
Gives you direct access to PostgreSQL through psycopg2's full API, exposed as MCP tools. You get connection pooling, transaction control with isolation levels, cursor management including server-side cursors, and COPY operations for bulk data transfer. It surfaces less common features like large object handling, hstore and composite type registration, and query parameter mogrification. Useful when you need programmatic database operations beyond basic queries, like managing transactions across multiple operations, working with PostgreSQL-specific types, or handling binary data through large objects. The tool set mirrors psycopg2's structure closely, so if you know the adapter, you'll recognize the operations.
- tools
- 37
- transport
- STDIO
- last updated
- Apr 6, 2026
Tools
37 toolsPublic tool metadata for what this MCP can expose to an agent.
connectCreate a new database connection
Create a new database connection
No parameter schema in public metadata yet.
close_connectionClose an existing connection
Close an existing connection
No parameter schema in public metadata yet.
get_connection_infoGet connection details
Get connection details
No parameter schema in public metadata yet.
begin_transactionStart a new transaction
Start a new transaction
No parameter schema in public metadata yet.
commit_transactionCommit the current transaction
Commit the current transaction
No parameter schema in public metadata yet.
rollback_transactionRollback the current transaction
Rollback the current transaction
No parameter schema in public metadata yet.
set_isolation_levelSet transaction isolation level
Set transaction isolation level
No parameter schema in public metadata yet.
create_cursorCreate a new cursor
Create a new cursor
No parameter schema in public metadata yet.
close_cursorClose a cursor
Close a cursor
No parameter schema in public metadata yet.
execute_queryExecute a SQL query
Execute a SQL query
No parameter schema in public metadata yet.
execute_manyExecute a query with multiple parameter sets
Execute a query with multiple parameter sets
No parameter schema in public metadata yet.
fetch_oneFetch one row
Fetch one row
No parameter schema in public metadata yet.
fetch_manyFetch multiple rows
Fetch multiple rows
No parameter schema in public metadata yet.
fetch_allFetch all remaining rows
Fetch all remaining rows
No parameter schema in public metadata yet.
quote_identifierQuote an SQL identifier
Quote an SQL identifier
No parameter schema in public metadata yet.
mogrifyReturn query string after parameter binding
Return query string after parameter binding
No parameter schema in public metadata yet.
register_jsonRegister JSON type adapter
Register JSON type adapter
No parameter schema in public metadata yet.
register_hstoreRegister hstore type adapter
Register hstore type adapter
No parameter schema in public metadata yet.
register_compositeRegister composite type adapter
Register composite type adapter
No parameter schema in public metadata yet.
copy_fromCopy data from file to table
Copy data from file to table
No parameter schema in public metadata yet.
copy_toCopy data from table to file
Copy data from table to file
No parameter schema in public metadata yet.
copy_expertExecute custom COPY statement
Execute custom COPY statement
No parameter schema in public metadata yet.
create_named_cursorCreate a server-side named cursor
Create a server-side named cursor
No parameter schema in public metadata yet.
scroll_cursorScroll through cursor results
Scroll through cursor results
No parameter schema in public metadata yet.
create_large_objectCreate or open a large object
Create or open a large object
No parameter schema in public metadata yet.
read_large_objectRead from a large object
Read from a large object
No parameter schema in public metadata yet.
write_large_objectWrite to a large object
Write to a large object
No parameter schema in public metadata yet.
get_server_versionGet PostgreSQL server version
Get PostgreSQL server version
No parameter schema in public metadata yet.
get_backend_pidGet backend process ID
Get backend process ID
No parameter schema in public metadata yet.
get_dsn_parametersGet connection parameters
Get connection parameters
No parameter schema in public metadata yet.
get_noticesGet database notices
Get database notices
No parameter schema in public metadata yet.
parse_dsnParse a connection string
Parse a connection string
No parameter schema in public metadata yet.
make_dsnCreate a connection string
Create a connection string
No parameter schema in public metadata yet.
cancel_queryCancel the current database operation
Cancel the current database operation
No parameter schema in public metadata yet.
set_sessionSet session parameters
Set session parameters
No parameter schema in public metadata yet.
list_connectionsList all active connections
List all active connections
No parameter schema in public metadata yet.
list_cursorsList all active cursors
List all active cursors
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
mcp-psycopg2
MCP server exposing psycopg2 PostgreSQL database adapter functionality.
mcp-name: io.github.daedalus/mcp-psycopg2
Install
pip install mcp-psycopg2
Usage
from mcp_psycopg2 import mcp
# Run the MCP server
mcp.run()
MCP Tools
The server exposes the following tools for interacting with PostgreSQL databases:
Connection Management
connect- Create a new database connectionclose_connection- Close an existing connectionget_connection_info- Get connection details
Transaction Management
begin_transaction- Start a new transactioncommit_transaction- Commit the current transactionrollback_transaction- Rollback the current transactionset_isolation_level- Set transaction isolation level
Details
- Repository
- github.com/daedalus/mcp-psycopg2
- Category
- Databases
- Package
mcp-psycopg2- Transport
- STDIO
- Registry
- MCP registry, active
More from daedalus
Related Databases MCP servers
View all
datamcp — Hosted Model Context Protocol for Databases, APIs, and Agent Memoryio.github.mironovisa/datamcpPostgreSQL, MySQL, OpenAPI/Swagger, and shared Agent Memory with scoped access.0stars
Sqlfmt Mcpmukundakatta/mcp-stackDeterministic SQL formatting across 19 dialects (postgres, mysql, snowflake, bigquery, etc.).0stars
Db Metadata Extractor Mcpoptisol-business/db-metadata-extractor-mcpExtract database metadata from PostgreSQL, Snowflake, SQL Server, BigQuery, and Oracle.0stars
MCP Toolbox for Databasesgoogleapis/mcp-toolboxMCP Toolbox for Databases enables your agent to connect to your database.16.9Kstars
Crawl4AI RAGcoleam00/mcp-crawl4ai-ragProvides web crawling, RAG, and knowledge-graph capabilities for AI agents with a Supabase-backed vector store.2.2Kstars
Monitorbetterdb-inc/monitorBetterDB MCP server - Valkey and Redis observability for Claude Code and other MCP clients1.3Kstars