Provides read-only access to query PostgreSQL databases with tools for running SELECT queries, listing tables, describing schemas, sampling data, counting rows, and searching columns across the database.
Click on "Install 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., "@Avanti Fellows PostgreSQL MCP Servershow me the schema for the students table"
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.
Avanti Fellows PostgreSQL MCP Server
Read-only MCP server for querying the Avanti Fellows DB Service (PostgreSQL).
What is this?
This is an MCP (Model Context Protocol) server that lets Claude Code, Cursor, and other AI tools query our PostgreSQL database directly. It's read-only - no writes allowed.
Available Tools
Tool | Description |
| Run any SELECT query |
| List all tables in the database |
| Get column info, primary keys, foreign keys |
| Get sample rows from a table |
| Count rows with optional WHERE clause |
| Find columns by name across all tables |
Installation
1. Install the package
pip install git+https://github.com/avantifellows/mcp-postgres.git2. Set up credentials
Add these to your shell profile (~/.zshrc or ~/.bashrc):
export AF_DB_HOST="af-database-host"
export AF_DB_PORT="5432"
export AF_DB_USER="your_username"
export AF_DB_PASSWORD="your_password"
export AF_DB_NAME="database_name"Then reload: source ~/.zshrc
3. Configure your AI tool
Claude Code
claude mcp add avanti-db -- avanti-mcp-postgresVerify it's working:
claude mcp listCursor
Add to ~/.cursor/mcp.json:
{
"mcpServers": {
"avanti-db": {
"command": "avanti-mcp-postgres",
"env": {
"AF_DB_HOST": "af-database-host",
"AF_DB_PORT": "5432",
"AF_DB_USER": "your_username",
"AF_DB_PASSWORD": "your_password",
"AF_DB_NAME": "database_name"
}
}
}
}Usage Examples
Once configured, just ask Claude/Cursor about the database:
"What tables are in the database?"
"Show me the schema for the students table"
"How many users signed up this month?"
"Find all columns with 'email' in the name"
"What does the enrollment data look like?"Updating
pip install --upgrade git+https://github.com/avantifellows/mcp-postgres.gitLocal Development
# Clone the repo
git clone https://github.com/avantifellows/mcp-postgres.git
cd mcp-postgres
# Create virtual environment
python -m venv venv
source venv/bin/activate
# Install in dev mode
pip install -e .
# Create .env file with credentials
cp .env.example .env
# Edit .env with your credentials
# Test the server
avanti-mcp-postgresSecurity Notes
This server is read-only - INSERT, UPDATE, DELETE are blocked
Uses your personal database credentials
Queries are logged locally but not sent anywhere
Don't commit credentials to git
Troubleshooting
"Connection refused"
Check that
AF_DB_HOSTis correct and accessible from your networkVerify you're on VPN if required
"Authentication failed"
Double-check
AF_DB_USERandAF_DB_PASSWORDEnsure your user has SELECT permissions
Server not showing in Claude Code
Run
claude mcp listto check statusTry removing and re-adding:
claude mcp remove avanti-db && claude mcp add avanti-db -- avanti-mcp-postgres
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.