SQL MCP Server (TypeScript)

what is SQL MCP Server?

SQL MCP Server is a TypeScript implementation of a Model Context Protocol (MCP) server that allows language models and other MCP-compatible clients to query PostgreSQL databases securely, even through SSH bastion tunnels.

how to use SQL MCP Server?

To use SQL MCP Server, clone the repository, install dependencies, configure the environment variables, and run the server using npx with the appropriate database connection string.

key features of SQL MCP Server?

• 🔒 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
• 🧠 Compatible with memory-bank-mcp-server
• ⚙️ Easily configurable via .env or environment variables
• 🧪 Fully testable with Jest and mocks

use cases of SQL MCP Server?

1. Securely querying PostgreSQL databases from AI-driven applications.
2. Integrating with other MCP-compatible tools for enhanced data processing.
3. Facilitating read-only access to AWS RDS instances for data analysis.

FAQ from SQL MCP Server?

• Can SQL MCP Server connect to any PostgreSQL database?

Yes, it can connect to any PostgreSQL database, including those hosted on AWS RDS.

• Is SQL MCP Server secure?

Yes, it supports SSH tunneling for secure access to private databases.

• How do I configure the server?

You can configure the server using environment variables or a .env file.