simple-psql-mcp
If you are the rightful owner of simple-psql-mcp 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.
Simple PostgreSQL MCP Server is a template project designed to help developers build their own Model Context Protocol (MCP) servers with ease.
The Simple PostgreSQL MCP Server is a template project aimed at developers who want to create their own Model Context Protocol (MCP) servers. MCP is a standard that allows Language Model Models (LLMs) to interact with external tools and data, facilitating the execution of commands and the attachment of data to conversations. This project provides a straightforward codebase with attached MCP documentation, making it easy to understand and adapt. The server is built to interact with a PostgreSQL database, offering tools to execute SQL queries and verify database connections, as well as resources to access schema information. It also includes prompt templates for generating consistent LLM instructions. The project requires Python 3.8+, a modern Python package manager like uv, and a PostgreSQL database. It includes a quick setup guide, instructions for connecting AI tools to the server, and an optional example database for testing. The project is experimental and not recommended for production use due to potential security vulnerabilities like SQL injection.
Features
- Tools: execute_query and test_connection for database interaction.
- Resources: Access to database schema and table information.
- Prompts: Templates for query generation and analytical query building.
- Quick setup guide for easy installation and configuration.
- Optional example database for testing and development.
Tools
execute_query
Execute SQL query
test_connection
Test database connection
