thrkrdk/postgresql-mcp-server
If you are the rightful owner of postgresql-mcp-server 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.
A Spring Boot application implementing an MCP server that provides read-only access to a PostgreSQL database via STDIO transport.
The Spring Boot Starter for PostgreSQL MCP Servers with Spring AI is a robust application designed to facilitate read-only access to PostgreSQL databases through the Model Context Protocol (MCP). This server leverages the power of Spring Boot and Spring AI to ensure efficient and secure data retrieval. It operates over STDIO transport, making it suitable for environments where direct database access is restricted or needs to be controlled. The application is built to handle SQL queries with pagination, ensuring that data retrieval is both efficient and manageable. By enforcing a read-only transaction model, it guarantees data integrity and security, preventing any unauthorized modifications to the database. The server also supports dynamic discovery of table schemas, providing up-to-date metadata information with each request.
Features
- Read-only SQL query execution with pagination
- Dynamic discovery of table schemas
- Enforcement of secure query practices
- Support for STDIO transport
- Integration with Spring AI for enhanced capabilities
Tools
query
Executes a read-only SQL query with paging