rspostgresmcp
rspostgresmcp is a library developed in Rust that provides an interface to PostgreSQL databases. This library simplifies database operations while leveraging Rust's safety and performance to enable efficient data management. It supports error handling and asynchronous processing, making it a user-friendly tool for developers.
GitHub Stars
1
User Rating
Not Rated
Favorites
0
Views
23
Forks
0
Issues
6
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
cherry-db-manager is a database management tool built with Rust. This tool simplifies database operations and provides efficient data management. Users can add, delete, and update data through an intuitive interface, and it supports multiple databases. Additionally, it includes performance optimization and error handling features.