mcp-psycopg2

MCP server exposing psycopg2 PostgreSQL database adapter functionality.

PyPI Python Ruff

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 connection
  • close_connection - Close an existing connection
  • get_connection_info - Get connection details

Transaction Management

  • begin_transaction - Start a new transaction
  • commit_transaction - Commit the current transaction
  • rollback_transaction - Rollback the current transaction
  • set_isolation_level - Set transaction isolation level

Cursor Operations

  • create_cursor - Create a new cursor
  • close_cursor - Close a cursor
  • execute_query - Execute a SQL query
  • execute_many - Execute a query with multiple parameter sets
  • fetch_one - Fetch one row
  • fetch_many - Fetch multiple rows
  • fetch_all - Fetch all remaining rows

SQL Composition

  • quote_identifier - Quote an SQL identifier
  • mogrify - Return query string after parameter binding

Type Registration

  • register_json - Register JSON type adapter
  • register_hstore - Register hstore type adapter
  • register_composite - Register composite type adapter

COPY Operations

  • copy_from - Copy data from file to table
  • copy_to - Copy data from table to file
  • copy_expert - Execute custom COPY statement

Server-Side Cursors

  • create_named_cursor - Create a server-side named cursor
  • scroll_cursor - Scroll through cursor results

Large Objects

  • create_large_object - Create or open a large object
  • read_large_object - Read from a large object
  • write_large_object - Write to a large object

Information

  • get_server_version - Get PostgreSQL server version
  • get_backend_pid - Get backend process ID
  • get_dsn_parameters - Get connection parameters
  • get_notices - Get database notices
  • parse_dsn - Parse a connection string
  • make_dsn - Create a connection string

Utility

  • cancel_query - Cancel the current database operation
  • set_session - Set session parameters
  • list_connections - List all active connections
  • list_cursors - List all active cursors

Development

git clone https://github.com/daedalus/mcp-psycopg2.git
cd mcp-psycopg2
pip install -e ".[test]"

# run tests
pytest

# format
ruff format src/ tests/

# lint
ruff check src/ tests/

# type check
mypy src/

Project links

Data verified by PyPI on Apr 6, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Latest release

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for dclavijo from gravatar.com dclavijo

Credits

Author: Darío Clavijo

GitHub Statistics

Data verified by PyPI on Apr 6, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License

MIT

Requires

Python >=3.11

Provides Extra

all dev lint test

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mcp_psycopg2-0.1.0.tar.gz (8.0 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

mcp_psycopg2-0.1.0-py3-none-any.whl (8.8 kB view details)

Uploaded Python 3

File details

Details for the file mcp_psycopg2-0.1.0.tar.gz.

File metadata

  • Download URL: mcp_psycopg2-0.1.0.tar.gz
  • Upload date:
  • Size: 8.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for mcp_psycopg2-0.1.0.tar.gz
Algorithm Hash digest
SHA256 6faa7cbc4437e1775158c3560fa15940242cfab714d5869271e9c46fe7b5dfe1
MD5 6bcf434abaaa42552cc55f31fa6a5a2e
BLAKE2b-256 f9f1998a7ca81a72054e4866ccfbfd5cf324161c49ca657c327205624606e32a

See more details on using hashes here.

Provenance

The following attestation bundles were made for mcp_psycopg2-0.1.0.tar.gz:

Publisher: pypi-publish.yml on daedalus/mcp-psycopg2

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file mcp_psycopg2-0.1.0-py3-none-any.whl.

File metadata

  • Download URL: mcp_psycopg2-0.1.0-py3-none-any.whl
  • Upload date:
  • Size: 8.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for mcp_psycopg2-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 a037e7e51fd357647b0ae9322617b70a58bdfad2370dc232676fa98541488b26
MD5 44a0485ccc5cbda829fec871403258e2
BLAKE2b-256 68ccb6e97556df5973dfbb833182a724ebe64e871d1297cf928f127ee8a52f05

See more details on using hashes here.

Provenance

The following attestation bundles were made for mcp_psycopg2-0.1.0-py3-none-any.whl:

Publisher: pypi-publish.yml on daedalus/mcp-psycopg2

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

This release

0.1.0 This release

2 files

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page