Command Palette

Search for a command to run...

UnylyUnyly
Весь каталог

Database Postgres

БесплатноНе проверен

MCP server for PostgreSQL. Read-only by default, row caps, timeouts, secrets never logged.

GitHubEmbed

Описание

MCP server for PostgreSQL. Read-only by default, row caps, timeouts, secrets never logged.

README

CI License: MIT npm Node >= 20

MCP servers that give AI clients safe, structured access to SQL databases.

One installable package per database engine. Every package exposes the same minimal two-tool surface, execute_sql and search_objects, with guardrails on by default: read-only mode, row caps, and statement timeouts.

Packages

Engine TypeScript (npm) Version
SQLite @database-mcp/sqlite npm
libSQL @database-mcp/libsql npm
MySQL @database-mcp/mysql npm
MariaDB @database-mcp/mariadb npm
Postgres @database-mcp/postgres npm

All five are published, provenance-attested, and pass the shared conformance suite against real databases in CI.

Python, Go, and Rust implementations are planned once the TypeScript line is complete. All packages, in every language, pass the same language-agnostic conformance suite, so behavior is identical everywhere.

Design principles

  • Two tools, no more. A tiny tool surface keeps the model's context window clean. search_objects progressively discloses schema: call it with no arguments to list tables, with a table name to get columns, indexes, and foreign keys.
  • Safe by default. Read-only mode is enforced in two layers: a conservative SQL guard, plus a session-level read-only setting in the database itself. Rows are capped (default 1000) and statements time out (default 30s).
  • Configured at launch, never via chat. Connection details come from flags, a YAML config file, or environment variables. Credentials are never accepted through a tool call.
  • Secrets never appear in logs. Passwords live in non-printable secret types, DSNs are sanitized before logging, and a redaction filter guards the log boundary.

Quick start

Pick your engine's package; each README has the full config surface. SQLite:

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["-y", "@database-mcp/sqlite", "--dsn", "/absolute/path/to/database.db"]
    }
  }
}

Networked engines take credentials from the environment (MYSQL_*, MARIADB_*, POSTGRES_*/DATABASE_URL, LIBSQL_URL/LIBSQL_AUTH_TOKEN), *_FILE mounted secrets, or a YAML file via --config. Never from a chat prompt.

Contributing

See CONTRIBUTING.md. The short version: the conformance suite is the definition of done. A change is mergeable only when conformance/run.mjs passes against every affected server.

License

MIT

from github.com/arifulislamat/database-mcp

Установить Database Postgres в Claude Desktop, Claude Code, Cursor

Рекомендуется · одна команда, все IDE
unyly install database-mcp-postgres

Ставит в Claude Desktop, Claude Code, Cursor и VS Code — сам разбирается с npx, uvx и сборкой из исходников.

Впервые? Поставь CLI: curl -fsSL https://unyly.org/install | sh

Или настроить вручную

Выполни в терминале:

claude mcp add database-mcp-postgres -- npx -y @database-mcp/postgres

FAQ

Database Postgres MCP бесплатный?

Да, Database Postgres MCP бесплатный — установка в пару кликов через Unyly без оплаты.

Нужен ли API-ключ для Database Postgres?

Нет, Database Postgres работает без API-ключей и переменных окружения.

Database Postgres — hosted или self-hosted?

Self-hosted: сервер запускается локально на твоей машине командой из раздела установки.

Как установить Database Postgres в Claude Desktop, Claude Code или Cursor?

Открой Database Postgres на unyly.org, выбери вкладку своего клиента (Claude Desktop, Claude Code, Cursor) и нажми Install — конфиг сгенерируется автоматически, без правки JSON.

Похожие MCP

Compare Database Postgres with

Не уверен что выбрать?

Найди свой стек за 60 секунд

Автор?

Embed-бейдж для README

Похожее

Все в категории data