MCP Server
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MCP Serverwhat were our Q3 sales by region?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MCP Server
Natural-language data querying via Model Context Protocol (MCP)
Built by: KMan | AI-Augmented Engineering Factory
What This Is
An MCP Server that wraps a client's internal API, enabling AI agents to answer natural-language questions against the connected dataset. Users query structured data using conversational language — no SQL, no API knowledge required.
Related MCP server: Database MCP
Architecture
MCP Client (Claude Desktop, custom clients)
│
│ JSON-RPC 2.0 over stdio
▼
┌─────────────────────────────────────────────────┐
│ MCP Server (FastMCP) │
│ ├── query_dataset — NL query against dataset │
│ ├── aggregate_data — count/sum/avg/min/max │
│ ├── search_similar — vector similarity search │
│ ├── list_collections — available data sources │
│ ├── describe_collection — schema inspection │
│ └── export_data — CSV/JSON export │
│ │
│ Agents: Query Understanding → Retrieval → NL │
└─────────────────────────────────────────────────┘
│
│ httpx (mock in PoC, real API in production)
▼
Client Internal APIQuick Start
# 1. Clone and install
git clone https://github.com/9KMan/JOB-20260613144931-000091.git
cd JOB-20260613144931-000091
python3 -m venv .venv && source .venv/bin/activate
pip install -e .
# 2. Configure (edit config.yaml)
cp config.yaml config.local.yaml
# 3. Run
python -m mcp_server.main
# 4. Test
curl http://localhost:8000/health
# 5. Run tests
pytest tests/ -vDocker
docker compose up --build
curl http://localhost:8000/healthTech Stack
Layer | Technology |
Runtime | Python 3.11+ |
MCP Framework | FastMCP (mcp Python SDK) |
Web | FastAPI |
Database | SQLite (PoC) / PostgreSQL (prod) |
HTTP Client | httpx |
Config | pydantic-settings |
Project Structure
src/mcp_server/
├── __init__.py # Package entry
├── __version__.py # Version
├── config.py # Settings management
├── database.py # ORM models (SQLAlchemy async)
├── cache.py # In-memory TTL cache
├── main.py # FastMCP server + REST endpoints
└── agents/
├── query_understanding.py # Intent classification
├── data_retrieval.py # API client (mock in PoC)
└── response_synthesis.py # NL response generationConfiguration
Copy config.yaml to config.local.yaml and set:
Variable | Description | Default |
| Internal API base URL |
|
| Internal API key |
|
| SQLite or PostgreSQL URL |
|
| Anthropic API key | (optional for PoC) |
| MCP authentication |
|
MCP Tools
Tool | Description |
| Execute natural-language query against dataset |
| Perform count/sum/avg/min/max aggregations |
| Vector similarity search (pgvector in prod) |
| List available data collections |
| Show schema for a collection |
| Export results as CSV/JSON |
Business Problem Solved
Domain experts typically need engineering support to query internal data. This MCP Server lets them ask questions in plain English — "What were our Q3 sales by region?" — and get structured answers immediately, without writing SQL or understanding the underlying API schema.
Limitations
⚠️ This is a PoC build. See OUT_OF_SCOPE.md for what's explicitly excluded.
Only mock data in PoC (no real API calls)
SQLite database (not production PostgreSQL)
Static API key auth (no OAuth2)
Rule-based query understanding (no LLM in PoC)
No multi-tenancy
Deploy to Production
Replace
DataRetrievalAgentwith real httpx calls to your internal APISwitch
database_urlfrom SQLite to PostgreSQL + pgvectorAdd TLS termination in front of the server
Replace static API key auth with OAuth2/OIDC
Review
OUT_OF_SCOPE.mdfor full checklist
This server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/9KMan/JOB-20260613144931-000091'
If you have feedback or need assistance with the MCP directory API, please join our Discord server