iwanbk/rspostgresmcp
If you are the rightful owner of rspostgresmcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A PostgreSQL Model Context Protocol (MCP) server that provides tools for interacting with PostgreSQL databases.
list_tables
Lists all tables in the connected PostgreSQL database.
get_schema
Returns detailed schema information for a specific table, including columns and indexes.
rspostgresmcp
Overview
A PostgreSQL Model Context Protocol (MCP) server that provides tools for interacting with PostgreSQL databases. This server allows AI models to query database schema information and table data through a standardized interface.
Features
- Connect to PostgreSQL databases
- List all tables in a database
- Get detailed schema information for specific tables, including columns and indexes
- Structured JSON responses for easy consumption by AI models
Available MCP Tools
List Tables
Lists all tables in the connected PostgreSQL database.
Tool Name: list_tables
Parameters: None
Returns: JSON array of table names
Get Table Schema
Returns detailed schema information for a specific table, including columns and indexes.
Tool Name: get_schema
Parameters:
name: Name of the table to get schema for Returns: JSON object containing column and index information
Schema Information
The schema information includes:
Columns
- Name
- Data type
- Maximum length (if applicable)
- Nullability
- Default value
Indexes
- Name
- Columns included in the index
- Whether the index is unique
- Whether the index is a primary key
Usage
./target/release/rspostgresmcp --dsn 'postgres://username:password@localhost:5432/database' --addr '127.0.0.1:9000'
License
MIT