PostgreSQL
Summary
A PostgreSQL MCP server that enables AI assistants to interact directly with PostgreSQL databases through a set of specialized tools. It provides capabilities for executing read and write SQL queries, creating tables, and listing database tables - all through the MCP protocol. Built with Go and leveraging the lib/pq driver, this implementation includes security features like query type validation and input sanitization, making it suitable for database management tasks while maintaining appropriate access controls. The server is easily configurable through environment variables and can be integrated with any MCP-compatible AI assistant.
Available Actions(5)
read_query
Execute SELECT queries on the PostgreSQL database. Parameters: query (string)
write_query
Execute INSERT, UPDATE, or DELETE queries on the PostgreSQL database. Parameters: query (string)
create_table
Create a new table in the PostgreSQL database. Parameters: schema (string)
list_tables
List all user tables in the database. Optional Parameters: schema (string)
explain_query
EXPLAIN a query on the PostgreSQL database.
Reseñas de la Comunidad
Aún no hay reseñas. ¡Sé el primero en reseñar!
Inicia sesión para unirte a la conversación
Highlight AI