---
title: "PostgreSQL MCP Integration"
sidebarTitle: "PostgreSQL"
description: "Guide for integrating PostgreSQL database operations with PraisonAI agents using MCP"
icon: "database"
---

## Add PostgreSQL Tool to AI Agent

```mermaid
flowchart LR
    In[Query] --> Agent[AI Agent]
    Agent --> Tool[PostgreSQL MCP]
    Tool --> Agent
    Agent --> Out[Answer]
    
    style In fill:#8B0000,color:#fff
    style Agent fill:#2E8B57,color:#fff
    style Tool fill:#336791,color:#fff
    style Out fill:#8B0000,color:#fff
```

## Quick Start

<Steps>
    <Step title="Install Dependencies">
        Make sure you have Node.js installed, as the MCP server requires it:
        ```bash
        pip install praisonaiagents mcp
        ```
    </Step>
    <Step title="Set up PostgreSQL">
        Ensure you have PostgreSQL running locally or specify your PostgreSQL connection URL.
    </Step>

    <Step title="Create a file">
        Create a new file `postgres_agent.py` with the following code:
        ```python
        from praisonaiagents import Agent, MCP
        import os

        # PostgreSQL connection string
        postgres_url = "postgresql://localhost/mydb"

        # Use a single string command with PostgreSQL configuration
        postgres_agent = Agent(
            instructions="""You are a helpful assistant that can interact with PostgreSQL databases.
            Use the available tools when relevant to manage database operations.""",
            llm="gpt-4o-mini",
            tools=MCP("npx -y @modelcontextprotocol/server-postgres", args=[postgres_url])
        )

        postgres_agent.start("List all tables in the database")
        ```
    </Step>

    <Step title="Run the Agent">
        Execute your script:
        ```bash
        python postgres_agent.py
        ```
    </Step>
</Steps>

<Note>
  **Requirements**
  - Python 3.10 or higher
  - Node.js installed on your system
  - PostgreSQL server running locally or remotely
  - OpenAI API key (for the agent's LLM)
</Note>