sql-mcp-server

sql-mcp-server

3.1

If you are the rightful owner of 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 implementation of a Model Context Protocol server that allows language models and other MCP-compatible clients to query PostgreSQL databases securely.

The SQL MCP Server is designed to facilitate secure and flexible access to PostgreSQL databases using the Model Context Protocol (MCP). It supports SSH bastion tunnels for secure connections to private AWS RDS instances and is built using TypeScript. The server uses stdin/stdout-based communication, making it suitable for various environments, including local, containerized, or AI-driven applications. It is easily configurable through environment variables or a .env file and is fully testable with Jest. The server is compatible with other MCP tools like the memory-bank-mcp-server and can be integrated with platforms such as Claude Desktop and Supabase.

Features

  • SSH bastion support: Provides secure access to private RDS instances via SSH tunnels.
  • PostgreSQL read-only query engine: Uses the 'pg' library to execute read-only queries on PostgreSQL databases.
  • STDIO-based MCP protocol transport: Facilitates communication using standard input/output streams.
  • Compatibility with memory-bank-mcp-server: Works seamlessly with the memory-bank-mcp-server for enhanced functionality.
  • Configurable via environment variables: Easily set up using a .env file or direct environment variable configuration.