MCP
PostgreSQL MCP Integration
Guide for integrating PostgreSQL database operations with PraisonAI agents using MCP
Add PostgreSQL Tool to AI Agent
Quick Start
1
Install Dependencies
Make sure you have Node.js installed, as the MCP server requires it:
2
Set up PostgreSQL
Ensure you have PostgreSQL running locally or specify your PostgreSQL connection URL.
3
Create a file
Create a new file postgres_agent.py
with the following code:
4
Run the Agent
Execute your script:
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)
Was this page helpful?