Provides tools for querying and managing employee data in a MongoDB collection, enabling CRUD operations and aggregation queries via natural language.
Uses NVIDIA's API (e.g., Google Gemma models) for AI planning and analysis tasks.
Allows using local AI models through Ollama for query planning and data analysis.
Enables integration with OpenAI's models for processing natural language queries and generating MongoDB commands.
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., "@Employee MCP Server (Mongo + AI Pipeline) Who earns the highest salary?"
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.
Architecture is now:
AI Planner
Mongo Executor
AI Analysis Result
No SQL path is used.
Default URI:
mongodb://admin:password@localhost:27017
On startup, the server seeds large dummy administration-style data (1500 employees) into:
DB: employee_admin
Collection: employees
Related MCP server: NestJS MongoDB MCP Server
Create .env (or set environment variables):
AI_PROVIDER=nvidia
AI_TIMEOUT_MS=30000
MONGO_URI=mongodb://admin:password@localhost:27017
MONGO_DB_NAME=employee_admin
MONGO_COLLECTION=employees
OLLAMA_HOST=http://127.0.0.1:11434
OLLAMA_MODEL=qwen2.5:3b
OLLAMA_CHAT_PATH=/api/chat
OPENAI_API_KEY=
OPENAI_MODEL=gpt-4.1-mini
OPENAI_BASE_URL=https://api.openai.com
CLAUDE_API_KEY=
CLAUDE_MODEL=claude-3-5-sonnet-20241022
CLAUDE_BASE_URL=https://api.anthropic.com
CLAUDE_MAX_TOKENS=2048
NVIDIA_API_KEY=
NVIDIA_MODEL=google/gemma-4-31b-it
NVIDIA_BASE_URL=https://integrate.api.nvidia.com
NVIDIA_MAX_TOKENS=16384
NVIDIA_TOP_P=0.95
NVIDIA_ENABLE_THINKING=trueSupported providers:
ollama
openai
claude
nvidia
npm install
node test-client.mjs --testsInteractive:
node test-client.mjsWho has the highest salary?
Who earns the least?
What is the difference between highest and lowest salary?
What is the average salary?
How many employees are there?
List employees in Administration
This server cannot be deployed
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Ask questions in plain language, get answers from your business database. No SQL required.
GibsonAI MCP server: manage your databases with natural language
Official Microsoft MCP Server to query Microsoft Entra data using natural language
