Registry / database / overmind-postgres-mcp

overmind-postgres-mcp

library1.2.0jsnpmunverified

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.

database llm-agents ai-ml vector-search

npm install overmind-postgres-mcp

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · OVERMIND-POSTGRES-

overmind-postgres-mcp

databasejavascriptv1.2.0

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

embedText

✓ import { embedText } from 'overmind-postgres-mcp/services/embeddings'

✗ import { embedText } from 'overmind-postgres-mcp'

This is a service export, not a main package export. Must use deep import path.

IntelligentSearchService

✓ import { IntelligentSearchService } from 'overmind-postgres-mcp/services/search'

✗ const { IntelligentSearchService } = require('overmind-postgres-mcp/services/search')

TypeScript library requires ESM; CommonJS require is not supported.

Default export (none)

✓ import { something } from 'overmind-postgres-mcp'

✗ import server from 'overmind-postgres-mcp'

Package does not have a default export; only named exports from subpaths.

Shows two ways: CLI MCP server setup via .mcp.json and .env, and programmatic embedding usage.

// 1. Set environment variables const POSTGRES_URL = process.env.POSTGRES_URL ?? 'postgresql://user:pass@localhost:5432/mydb'; const OPEN_ROUTER_API_KEY = process.env.OPEN_ROUTER_API_KEY ?? 'sk-or-v1-...'; // 2. Run the MCP server via CLI // npx -y overmind-postgres-mcp // 3. Or programmatically use embeddings import { embedText } from 'overmind-postgres-mcp/services/embeddings'; async function main() { const { embedding, model } = await embedText('Your text here'); console.log('Embedding vector:', embedding.slice(0, 5), '...'); console.log('Model used:', model); } main().catch(console.error);

Debug

Known issues

breakingRequires Node.js version >=20 and <25. Older versions will not work.

fix

Upgrade Node.js to v20 or v21/v22 (but not v25). Use nvm or similar.

affects: <20 || >=25

deprecatedThe 'embedText' function uses an embedding model that may change without notice. For production, pin the model version.

fix

Check documentation for available model options and pass explicit model parameter.

affects: >=1.0.0

gotcha.env file must contain OPEN_ROUTER_API_KEY; the package will fail silently if missing.

fix

Ensure OPEN_ROUTER_API_KEY is set in environment or .env file.

affects: >=1.0.0

gotchaThe PostgreSQL database must have the pgvector extension installed for embeddings to work.

fix

Run 'CREATE EXTENSION IF NOT EXISTS vector;' on your PostgreSQL instance.

affects: >=1.0.0

breakingGlobal installation (npm install -g) may conflict with other MCP servers if not scoped correctly.

fix

Use npx to avoid global conflicts, or install locally.

affects: >=1.0.0

Errors

Common errors & fixes

Error: Cannot find module 'overmind-postgres-mcp/services/embeddings'

Typo in import path or wrong installation path.

fix

Install locally: `npm install overmind-postgres-mcp`, then use correct import path.

Error: The module 'overmind-postgres-mcp' does not provide a default export.

Trying to import default export when package has none.

fix

Use named exports from subpaths, e.g., `import { embedText } from 'overmind-postgres-mcp/services/embeddings'`.

TypeError: Cannot read properties of undefined (reading 'query')

POSTGRES_URL not set or incorrect.

fix

Set POSTGRES_URL in .env or environment variables.

Error: connect ECONNREFUSED ::1:5432

PostgreSQL not running or not accessible.

fix

Start PostgreSQL service and verify connection string.

Upgrade

Version history

1.2.0latest on npm

Audit

Dependencies

pgrequiredPostgreSQL client for database connectivity

zodrequiredSchema validation for MCP tool inputs and responses

Agent activity

42 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/DeamonDev888/PostgreSQL-MCP-Serveur ↗

packagehttps://www.npmjs.com/package/overmind-postgres-mcp ↗

homepagehttps://discord.gg/4AR82phtBz ↗