simple-psql-mcp
This project is a template for creating MCP servers, focusing on simplicity and adaptability. It is designed for PostgreSQL databases and provides tools, resources, and prompts to facilitate interaction between LLMs and external data sources. The project includes comprehensive documentation and an option to generate example databases for testing.
Simple PostgreSQL MCP Server
This project is a template for building Model Context Protocol (MCP) servers, specifically tailored for PostgreSQL. The implementation features tools for executing SQL queries and verifying database connections, resources for schema information, and prompts for query generation. It requires Python 3.8+ and PostgreSQL and utilizes the UV package manager. The project includes an MCP Inspector for interacting with the server via a web interface, and detailed documentation is provided for setup and configuration, including the ability to create an example database using Docker.