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., "@PostgreSQL MCP ServerShow me the schema for the users 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.
PostgreSQL MCP Server
An MCP (Model Context Protocol) server that connects to a local PostgreSQL database, enabling AI assistants to query and manage your database.
Tools Provided
Tool | Description |
query | Execute read-only SQL (SELECT, SHOW, EXPLAIN) |
execute | Execute write SQL (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) |
list_tables | List all tables in a schema |
describe_table | Show columns, types, keys, and indexes for a table |
list_schemas | List all user schemas in the database |
Resources
schema-overview (
postgres://schema/overview) — Full database schema overview in Markdown
Setup
1. Install dependencies
npm install2. Configure your database connection
Edit the .env file with your PostgreSQL credentials:
PG_HOST=localhost
PG_PORT=5432
PG_USER=postgres
PG_PASSWORD=your_password_here
PG_DATABASE=your_database_name3. Build
npm run build4. Configure in VS Code (Copilot / Claude Desktop)
Add this to your MCP settings:
VS Code (.vscode/settings.json or User Settings):
{
"mcp": {
"servers": {
"postgres": {
"command": "node",
"args": ["c:\\Users\\Admin\\Desktop\\postgree mco\\dist\\index.js"],
"env": {
"PG_HOST": "localhost",
"PG_PORT": "5432",
"PG_USER": "postgres",
"PG_PASSWORD": "your_password",
"PG_DATABASE": "your_database"
}
}
}
}
}Claude Desktop (claude_desktop_config.json):
{
"mcpServers": {
"postgres": {
"command": "node",
"args": ["c:\\Users\\Admin\\Desktop\\postgree mco\\dist\\index.js"],
"env": {
"PG_HOST": "localhost",
"PG_PORT": "5432",
"PG_USER": "postgres",
"PG_PASSWORD": "your_password",
"PG_DATABASE": "your_database"
}
}
}
}Usage Examples
Once configured, you can ask the AI assistant things like:
"List all tables in my database"
"Describe the users table"
"SELECT * FROM orders WHERE created_at > '2025-01-01'"
"Create a new table called products"
This server cannot be installed
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.