{"id":28024,"library":"overmind-postgres-mcp","title":"Overmind PostgreSQL MCP Server","description":"A comprehensive MCP server for PostgreSQL database interaction, integrating semantic intelligence via embeddings and RAG (Retrieval-Augmented Generation). Version 1.2.0, released regularly. Key differentiators: built-in high-performance memory (4096D) with pgvector support for SOTA embeddings, segregated agent memory per user, autonomous navigation allowing natural language queries without SQL. Provides both a CLI MCP server for tools like table browsing, query execution, and schema extraction, and a TypeScript library for programmatic embedding and hybrid search. Requires Node.js >=20 <25 and a PostgreSQL instance with pgvector extension. Competes with other PostgreSQL MCP servers but focuses on agent-oriented memory and semantic capabilities.","status":"active","version":"1.2.0","language":"javascript","source_language":"en","source_url":"https://github.com/DeamonDev888/PostgreSQL-MCP-Serveur","tags":["javascript","mcp","postgresql","postgres","database","sql","fastmcp","typescript","model-context-protocol"],"install":[{"cmd":"npm install overmind-postgres-mcp","lang":"bash","label":"npm"},{"cmd":"yarn add overmind-postgres-mcp","lang":"bash","label":"yarn"},{"cmd":"pnpm add overmind-postgres-mcp","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"PostgreSQL client for database connectivity","package":"pg","optional":false},{"reason":"Schema validation for MCP tool inputs and responses","package":"zod","optional":false}],"imports":[{"note":"This is a service export, not a main package export. Must use deep import path.","wrong":"import { embedText } from 'overmind-postgres-mcp'","symbol":"embedText","correct":"import { embedText } from 'overmind-postgres-mcp/services/embeddings'"},{"note":"TypeScript library requires ESM; CommonJS require is not supported.","wrong":"const { IntelligentSearchService } = require('overmind-postgres-mcp/services/search')","symbol":"IntelligentSearchService","correct":"import { IntelligentSearchService } from 'overmind-postgres-mcp/services/search'"},{"note":"Package does not have a default export; only named exports from subpaths.","wrong":"import server from 'overmind-postgres-mcp'","symbol":"Default export (none)","correct":"import { something } from 'overmind-postgres-mcp'"}],"quickstart":{"code":"// 1. Set environment variables\nconst POSTGRES_URL = process.env.POSTGRES_URL ?? 'postgresql://user:pass@localhost:5432/mydb';\nconst OPEN_ROUTER_API_KEY = process.env.OPEN_ROUTER_API_KEY ?? 'sk-or-v1-...';\n\n// 2. Run the MCP server via CLI\n// npx -y overmind-postgres-mcp\n\n// 3. Or programmatically use embeddings\nimport { embedText } from 'overmind-postgres-mcp/services/embeddings';\n\nasync function main() {\n  const { embedding, model } = await embedText('Your text here');\n  console.log('Embedding vector:', embedding.slice(0, 5), '...');\n  console.log('Model used:', model);\n}\nmain().catch(console.error);","lang":"typescript","description":"Shows two ways: CLI MCP server setup via .mcp.json and .env, and programmatic embedding usage."},"warnings":[{"fix":"Upgrade Node.js to v20 or v21/v22 (but not v25). Use nvm or similar.","message":"Requires Node.js version >=20 and <25. Older versions will not work.","severity":"breaking","affected_versions":"<20 || >=25"},{"fix":"Check documentation for available model options and pass explicit model parameter.","message":"The 'embedText' function uses an embedding model that may change without notice. For production, pin the model version.","severity":"deprecated","affected_versions":">=1.0.0"},{"fix":"Ensure OPEN_ROUTER_API_KEY is set in environment or .env file.","message":".env file must contain OPEN_ROUTER_API_KEY; the package will fail silently if missing.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Run 'CREATE EXTENSION IF NOT EXISTS vector;' on your PostgreSQL instance.","message":"The PostgreSQL database must have the pgvector extension installed for embeddings to work.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Use npx to avoid global conflicts, or install locally.","message":"Global installation (npm install -g) may conflict with other MCP servers if not scoped correctly.","severity":"breaking","affected_versions":">=1.0.0"}],"env_vars":null,"last_verified":"2026-05-09T00:00:00.000Z","next_check":"2026-08-07T00:00:00.000Z","problems":[{"fix":"Install locally: `npm install overmind-postgres-mcp`, then use correct import path.","cause":"Typo in import path or wrong installation path.","error":"Error: Cannot find module 'overmind-postgres-mcp/services/embeddings'"},{"fix":"Use named exports from subpaths, e.g., `import { embedText } from 'overmind-postgres-mcp/services/embeddings'`.","cause":"Trying to import default export when package has none.","error":"Error: The module 'overmind-postgres-mcp' does not provide a default export."},{"fix":"Set POSTGRES_URL in .env or environment variables.","cause":"POSTGRES_URL not set or incorrect.","error":"TypeError: Cannot read properties of undefined (reading 'query')"},{"fix":"Start PostgreSQL service and verify connection string.","cause":"PostgreSQL not running or not accessible.","error":"Error: connect ECONNREFUSED ::1:5432"}],"ecosystem":"npm","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}