When you ask an AI to write MySQL queries, you must give it the project’s schema. In very large projects a single database can have hundreds of tables. If you feed the whole schema dump to the AI, the context becomes too long and the request often fails.

To fix this, I thought an MCP server could return a neatly compressed schema so SQL generation works better. While learning MCP, I built a server that first fetches a table list and then fetches detailed information only for the tables you need.

More details in the blog post: https://medium.com/@shibayu36/i-built-an-mcp-server-that-com...

Comments (0)

No comments yet

Imane Khelif, the IOC, World Boxing and mandatory sex testing (3wiresports.com)

Show HN: Make customized pet portraits for a dollar each (pet-picture-ai.vercel.app)

The other technology adoption curve (kyefox.com)

Computers of the Future (worksinprogress.news)

Why can't we put metal objects in a microwave? (engineering.mit.edu)

Fast Character Classification with Z3 (lemire.me)

The Other Two (worldhistory.substack.com)

Boop Newsletter (boopnews.com)

Show HN: Tarzan – Turn any email into a live blog post (Go and Vue.js) (tarzan.meysam.io)

What Web Browsing Data Tells Us About How AI Appears Online (pewresearch.org)

Easily Understand Rdma Technology (naddod.com)

Living to Die Well (nytimes.com)

Contextual RAG on Cloudflare Workers (boristane.com)

LLM tutored writing practice for secondary language acquisition (hiandrewquinn.github.io)

Python, notebooks, no code recipes, AI = new desktop app for data analysis (mljar.com)

RDMA in AI Architectures (medium.com)

TPDE: Fast, Adaptable, Compiler Back End Framework [pdf] (arxiv.org)

Show HN: Synchronize AI coding–agent knowledge files across your project (github.com)

New, handwritten Maimonides texts discovered at Cambridge University Library (cam.ac.uk)

AI didn't kill Stack Overflow (infoworld.com)

Termux Udocker: Run Docker images in Termux using proot (github.com)

Law enforcement used license-plate readers to search for woman who had abortion (theguardian.com)

Indian Recipes List (indianrecipeslist.com)

Show HN: DepthNet – AI agents with continuous thinking loops (github.com)

Customer Loyalty Management Platform Through Cashback (byteback.pro)

Microsoft promises it's ending USB-C confusion with Windows 11 certified program (tomshardware.com)

Add PUT, PATCH, and DELETE to form method attribute (github.com)

The Light Beyond Sight (aeon.co)

Mcp-scan: constrain, log and scan your active MCP connections (github.com)

Machined (machined.ai)

Real TikTokers are pretending to be Veo 3 AI creations for fun, attention (arstechnica.com)

Google AI Edge Gallery (github.com)

A Russian Hacker Walked into a Cafeteria [video] (youtube.com)

Context is all you need (fakepixels.substack.com)

What is fault-tolerant quantum computing? – IBM Quantum Computing Blog (ibm.com)

Almost three centuries of the Belfast News Letter go online (theguardian.com)

Dutch government's reliance on U.S. cloud services greater than expected (nltimes.nl)

From tensors to consciousness with Apple's MLX (github.com)

The ESLint Logo Story: How Non-Programmers Can Shape Open Source (omerbalyali.com)

Ask HN: Know Your Developers

EU to launch age-check app, precursor to the digital identity wallet due in 2026 (ft.com)

The Fish That Climbed a Mountain (longreads.com)

Learn, build, judge, ship: What to look for in your first (AI) marketer (gkogan.co)

Report says Sony won't produce smartphones in its own factories anymore (techissuestoday.com)

The Colorado River Basin has lost as much groundwater as the volume of Lake Mead (cnn.com)

My first attempt at iOS app development (mgx.me)

FujiNet – open-source project to bring 8-bit computers online (including gaming) (retrorgb.com)

CARDIAC – CARDboard Illustrative Aid to Computation (en.wikipedia.org)

Show HN: Meto – Metabolic Health 3.0 with AI, Wearables, and Precision Care (meto.co)

Computer Stores of the 1970s and 1980s (2022) (pcmag.com)

Show HN: MCP server that compresses and serves MySQL schema data

Comments (0)