What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the pgvector MCP server?
Similarity search, hybrid search, and index management for pgvector-backed PostgreSQL tables
How to install pgvector
Copy-paste configuration for popular MCP clients.
DATABASE_URLrequiredsecretPostgreSQL connection string, e.g. postgresql://user:password@host:5432/dbname
MCP_PGVECTOR_READ_ONLYSet to 'true' to disable upsert_embedding and create_vector_index
{
"mcpServers": {
"pgvector": {
"command": "uvx",
"args": [
"mcp-server-pgvector"
],
"env": {
"DATABASE_URL": "<YOUR_DATABASE_URL>",
"MCP_PGVECTOR_READ_ONLY": "<YOUR_MCP_PGVECTOR_READ_ONLY>"
}
}
}
}Related MCP servers
Sourced, dated SK/CZ/AT/EU civic, tax and legal facts for AI agents. Read via MCP, not guesswork.
View repository →
Reddit Ads MCP
MCP server for the Reddit Ads API. List accounts, campaigns, ads, and pull reports.
AI agents propose database changes as reviewable requests — no direct write access.

PyScrappy
AI-native web scraping toolkit with 22+ tools for structured, LLM-ready data extraction

PaperBanana-CN
Generate academic diagrams and statistical plots with independent VLM and image model connections.

ClauseKeeper Compliance Scanner
Scan website legal docs for missing or stale compliance clauses. Rule-based, no LLM.
