sql-mcp-server

sql-mcp-server

0
databases

The SQL MCP Server is a TypeScript-based implementation that facilitates secure querying of PostgreSQL databases through the Model Context Protocol. It supports connection through SSH bastion tunnels and is designed for compatibility with various AI tools and platforms.

SQL MCP Server (TypeScript)

This project provides a TypeScript implementation of a Model Context Protocol (MCP) server that enables language models and other MCP-compatible clients to query PostgreSQL databases via SSH bastion tunnels when required.

Features

  • SSH bastion support for secure access to private RDS instances
  • PostgreSQL read-only query engine
  • STDIO-based MCP protocol transport
  • Easy configuration via .env or environment variables
  • Compatible with memory-bank-mcp-server
  • Fully testable with Jest and mocks

Installation

Clone the repository, install dependencies, and configure via an optional .env file.

Usage

Run the server using npx and set the necessary environment variables for direct connection without SSH tunnels.

License

MIT

Contribution Guide

Community contributions are welcome.