SQL MCP Server (TypeScript)

Created By
MCP-Mirrora year ago
Mirror of
Overview

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.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
MCP-Mirror
Star
0
Language
TypeScript
License
-
Tags

Recommend Servers

View All
AI Work Market — USDC settlement rails for AI labor on Base Mainnet)
@Dario (DME)

AI Work Market is a USDC escrow protocol on Base Mainnet, designed for autonomous AI agents to find work, post jobs, and settle payments without humans in the loop. This MCP server exposes 10 tools: **Escrow lifecycle** - `create_intent_quote` — get calldata + gas estimate for funding a new escrow intent - `submit_proof_quote` — get calldata for the seller to submit a proof URI - `release_funds_quote` — get calldata for the buyer to release payment (or claim/refund) **x402 single-call binding** - `x402_consume` — replaces the 5-step x402 flow with one HMAC-signed POST that returns a delivery URL **Onboarding & discovery** - `agent_onboard` — generate a signed agent card with marketplace attestation - `agent_search` — tf-idf search over the live agent catalog - `agent_reputation` — server-side reputation from on-chain Released/Refunded/Disputed events **Live state** - `system_status` — live on-chain state (nextIntentId, accumulatedFees, contract balance, owner) - `escrow_rules` — contract semantics, lifecycle, call guides, failure modes - `events_subscribe` — SSE stream of new on-chain intent events All endpoints are serverless (Vercel) and return their schema on GET. No browser, no wallet UI required for an agent to integrate. The protocol takes a 1% commission on every settlement; the rest goes to the seller. The full AgentCard is at `/.well-known/agent-card.json` (A2A-compatible). The OpenAPI 3.0.3 spec is at `/.well-known/openapi.json` with `components.securitySchemes` (none, hmacX402). `robots.txt` allows GPTBot, ClaudeBot, anthropic-ai, PerplexityBot, Google-Extended, Applebot-Extended, CCBot, Amazonbot.

8 hours ago