MCP server runs one SELECT across Postgres, MySQL, S3 and local files
slotix · reddit · 2026-09-11
A developer showcases an MCP server that federates a single SELECT across engines: a live Postgres table LEFT JOINed against a MySQL table or a Parquet file in S3 or on disk — handy for verifying migration exports against live tables without staging.
- Read-only by design: no update/drop/alter tool exists, every tool declares readOnlyHint; connection strings pass only at startup, never through tool calls or logs
- Run via one npx line or a container; npx covers Linux/Windows x64, macOS needs the container
- Supports Postgres, MySQL, S3, local Parquet/CSV/JSON; Snowflake browsable but not federated
- Free to use, closed source
More from coding & agent
- OpenAI ships GPT-Live prompting guide: copying your old prompts won't hit SOTA — craigsdennis · 2026-09-11
- Meta's Auto-RecSys runs autonomous research on industry-scale recommenders — omarsar0 · 2026-09-11
- Hamel Husain: The Revenge of the Data Scientist — AI Evals are the real job — HamelHusain · 2026-09-11
- One prompt builds a browser Rollercoaster Tycoon clone: "We are so EARLY" — _philschmid · 2026-09-11
- How to feed Claude Code local meeting notes without shipping transcripts to the cloud — Tight_Claim8869 · 2026-09-11
- Every Builds Personal Benchmarks for Each Employee — Finds a Smaller Model Beats the Big Ones — every · 2026-09-11