Skip to main content
Glama
lokeshkundi15

Enterprise-MCP-Data-Agent

by lokeshkundi15
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Local

P4: Enterprise MCP Data Agent (Local LLM + Secure PostgreSQL Integration)

An enterprise-grade, secure, and privacy-first Autonomous Data Agent built using the Model Context Protocol (MCP), FastMCP, LlamaIndex Workflows, and a localized LLaMA 3.2 model via Ollama. This agent acts as an automated SQL assistant that interacts securely with an on-premise PostgreSQL database using dynamic tool-calling capability, ensuring no database schemas are exposed raw to the external world.

🚀 Key Features

  • Model Context Protocol (MCP): Implements modern 2026 standardized client-server architecture (FastMCP) over Server-Sent Events (SSE).

  • Privacy-First Architecture: Utilizes local llama3.2:1b for zero-data leak enterprise compliances.

  • Dynamic Tool Calling: Built-in SQL execution layer protecting database context via strict system prompting (list_tables, read_data, add_data).

  • Streamlit User Interface: A production-style, dynamic chat interface supporting streaming statuses of agent thoughts and backend tool invocations.

Related MCP server: PostgreSQL MCP Server

🛠️ Tech Stack

  • AI Framework: LlamaIndex (FunctionAgent Workflows)

  • MCP Server Framework: FastMCP (Python)

  • Database Driver: Psycopg3 (Modern PostgreSQL)

  • Local LLM Engine: Ollama (LLaMA 3.2 1B)

  • Frontend UI: Streamlit

📁 Project Structure

  • server.py - The standalone FastMCP server exposing database query and schema capabilities securely.

  • agent_notebook.ipynb - Core testing and modular workflow pipeline using LlamaIndex client specs.

  • app.py - Production-ready UI frontend wrapping the async agent loop.

🏃 How to Run

Step 1: Start the FastMCP Server

Ensure your local PostgreSQL database is up and matching the config, then run:

python server.py --server_type sse --port 8000

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • PostgreSQL MCP Server

    reckersai
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables natural language interaction with PostgreSQL databases, supporting query execution, schema management, data operations, user management, and database maintenance with secure remote access via HTTP/SSE transport.
    MIT

  • mcp-server-postgres

    Ismail-2001
    F
    license
    Not graded
    quality
    F
    maintenance
    Provides a secure, schema-aware PostgreSQL database agent for LLMs, enabling natural language queries and validated SQL execution with strong security guardrails.
    19 npm
    5
    -