Skip to content

andyWang1688/sql-query-mcp

MCP Data & Storage

A general‑purpose MCP server that lets AI interact with multiple databases (PostgreSQL, MySQL, Hive) through a controlled, read‑only interface

Python Latest v0.4.0 · 12d ago Security brief →

Features

  • Discover database schema and sample data via API calls
  • Run bounded SELECT queries (`run_select`) or start long‑running async reads (`start_query`/`get_query`)
  • Export PostgreSQL/MySQL query results to CSV/XLSX files on the server
  • Import local CSV/XLSX files into existing tables with strict column matching
  • Validate SQL with `sqlglot` and enforce read‑only, single‑statement policies

Recent releases

View all 7 releases →
No immediate action
v0.2.0 New feature

Controlled table file imports

No immediate action
v0.1.2 Bug fix

Rerunnable releases

No immediate action
v0.1.1 New feature

Automated PyPI release

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

About

Stars
4
Forks
0
Languages
Python Dockerfile

Install & Platforms

Install via
pipx

Beta — feedback welcome: [email protected]