About Rspostgresmcp
Rspostgresmcp is an MCP server in the Data category: a PostgreSQL Model Context Protocol (MCP) server in Rust.
Install
git clone https://github.com/iwanbk/rspostgresmcpThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Ask AI
Ask AI about Rspostgresmcp
Powered by Claude · Grounded in docs
Security checks
- ✓README presentThe repository ships documentation.
5 checks have not been run yet.
README
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
README copy captured when this server was indexed; it may lag the repository. The original is authoritative.