AI Engineering Assistant MCP Server
Provides tools for querying and inspecting backend job failures stored in a SQLite database, including listing failed jobs, fetching job details, and searching jobs.
Click on "Deploy 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., "@AI Engineering Assistant MCP ServerWhat jobs failed in the last 24 hours and why?"
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.
AI Engineering Assistant (MCP Server)
An AI ops assistant that answers questions about backend job failures by calling real tools over MCP (Model Context Protocol). The LLM (via Groq) never guesses -- it calls MCP tools backed by a SQLite jobs table to get real data, then summarizes.
User -> FastAPI /chat -> LangGraph agent (Groq LLM) -> MCP tools -> SQLiteStructure
app/
db/ SQLAlchemy models + seed data (Job table)
mcp/ MCP server exposing job-ops tools (get_failed_jobs, search_jobs, ...)
agent/ LangGraph ReAct agent wired to Groq + MCP tools
api/ FastAPI routes (/chat, /health)
main.py FastAPI entrypointRelated MCP server: Data Agent Connector
Setup
python -m venv .venv
.venv\Scripts\activate # Windows
pip install -r requirements.txt
copy .env.example .env
# edit .env and set GROQ_API_KEY
python -m app.db.seed # creates + seeds app/db/ops.dbRun (two processes)
Terminal 1 -- MCP server (tools + SQLite):
python -m app.mcp.serverTerminal 2 -- FastAPI app (agent + chat endpoint):
uvicorn main:app --reload --port 8000Try it
curl -X POST http://localhost:8000/chat \
-H "Content-Type: application/json" \
-d "{\"message\": \"What jobs failed recently and why?\"}"The agent will call get_failed_jobs (and possibly get_job_by_id /
search_jobs) via MCP, then summarize the real failures from SQLite.
Roadmap
Tool permission tiers (read / write / dangerous) with human-in-the-loop approval
Docker / monitoring / GitHub MCP tool servers
Auth (API key or JWT) on the FastAPI layer
Streaming responses
Docker Compose for MCP server + API + Postgres
This server cannot be deployed
Maintenance
Related MCP Connectors
MCP-Native LLM Orchestration Agent
Let AI agents query data and act across all your business apps via MCP.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
The BigQuery remote MCP server is a fully managed service that uses the Model Context Protocol to connect AI applications and LLMs to BigQuery data sources. It provides secure, standardized tools for AI agents to list datasets and tables, retrieve schemas, generate and execute SQL queries through natural language, and analyze data—enabling direct access to enterprise analytics data without requiring manual SQL coding.
Related MCP Servers
- -licenseNot gradedqualityAmaintenanceProvides an LLM access to the Exasol database via MCP tools, enabling reading of database metadata and execution of data reading queries.18-
- AlicenseNot gradedqualityDmaintenanceEnables SQL agents to connect to any SQLAlchemy-supported database via MCP, providing read-only SQL querying, automatic table summarization, and column content search.4Apache 2.0
- FlicenseNot gradedqualityBmaintenanceEnables natural-language querying of a SQLite database through a locally served, fine-tuned text-to-SQL model exposed as an MCP tool, offering fast and cost-free SQL generation and execution.1-
- AlicenseNot gradedqualityCmaintenanceEnables AI agents to read-only query a SQLite database, inspect schema and table summaries, and execute SELECT queries with pagination through MCP.MIT