ls-mcp-server
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., "@ls-mcp-serverRun a SQL query to show all customers who signed up in 2024"
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.
ls-mcp-server
MCP server (FastMCP) that exposes two tools:
query_struct_data— Generates/validates/executes SQL queries via the SQL agent.search_kb— Answers questions grounded in the RAG knowledge base via the RAG agent.
Quick start
1) Install dependencies
pip install -r requirements.txt2) Configure environment
Create a .env file (example values shown in .env.example if present) and set any credentials/connection strings required by:
SQL Server (ODBC / connection settings)
LLM provider (OpenAI / Groq / Ollama)
Azure Search (if used)
3) Run the MCP server
python main.pyServer runs on:
HTTP transport
0.0.0.0:8000
Related MCP server: Business MCP Server
MCP inspector
Inspect the exposed tools for main.py:
mcp inspector --file main.pyIf your installation uses the module form:
python -m mcp_inspector --file main.pyProject structure
main.py— MCP server + tool definitionsRAG_AGENT/— RAG agent implementationSQL_AGENT/— SQL agent implementationconfig/— configuration / LLM factory
Tests
pytest -qRelated MCP Connectors
- dataOAuthco.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
- OleanderOAuthdev.oleander
The all-in-one data stack for agents. Upload files, run SQL, evolve tables, and render charts.
Curated operational knowledge for AI agents. 2 tools. Paid.
Search your knowledge bases from any AI assistant using hybrid RAG.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceEnables natural language database operations and semantic document search through SQLite and vector database integration. Converts plain English instructions into SQL queries and provides RAG capabilities for uploaded documents.-
- FlicenseNot gradedqualityDmaintenanceEnables AI to query a business database for customers, orders, and revenue using natural language through safe, well-defined tools.-
- FlicenseNot gradedqualityCmaintenanceEnables RAG (Retrieval-Augmented Generation) with tools for vector search, document access, and OpenAI integration, plus MySQL storage and file system operations via MCP.-
- AlicenseNot gradedqualityCmaintenanceEnables AI agents to interact with PostgreSQL or MySQL databases using natural language. Supports SQL queries, schema discovery, and pre-built aggregations without writing SQL.191 npmMIT