t3ta_sql-mcp-server
If you are the rightful owner of t3ta_sql-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.
The SQL MCP Server is a TypeScript-based implementation designed to facilitate secure and flexible querying of PostgreSQL databases using the Model Context Protocol (MCP).
The SQL MCP Server is a robust and versatile server implementation written in TypeScript, designed to enable seamless interaction between language models and PostgreSQL databases. It leverages the Model Context Protocol (MCP) to provide a standardized communication interface, allowing clients to execute read-only queries on PostgreSQL databases. The server is particularly suited for environments where secure database access is paramount, such as when dealing with AWS RDS instances. It supports SSH bastion tunnels to ensure secure connections to private databases, making it ideal for both local and cloud-based deployments. The server communicates via stdin/stdout, which makes it compatible with a variety of platforms, including containerized environments and AI-driven applications. With its focus on security, flexibility, and ease of configuration, the SQL MCP Server is a valuable tool for developers looking to integrate database querying capabilities into their applications.
Features
- SSH bastion support for secure access to private RDS instances via SSH tunnels
- PostgreSQL read-only query engine using the `pg` library
- STDIO-based MCP protocol transport
- Easily configurable via `.env` or environment variables
- Fully testable with Jest and mocks