v1.0.0 — First Stable Release

multi-postgres-mcp-server v1.0.0

Multi-database PostgreSQL MCP server for AI coding assistants (Claude Code, Cursor, Windsurf).

Highlights

• 7 MCP tools: pg_list_databases, pg_query, pg_list_tables, pg_describe_table, pg_list_schemas, pg_health_check, pg_explain
• Multi-database: Manage many PostgreSQL connections from a single MCP server
• Security: SQL injection protection (multi-statement detection), read-only transactions by default, SSL/TLS, parameterized queries
• Connection pooling: pg.Pool with lazy init, hot-reload via config hash comparison
• Config flexibility: JSON file with env var substitution (${VAR}), connection strings, --label isolation
• Config caching: 5s TTL with mtime check for reduced I/O
• Zod validation: Full config validation with descriptive errors
• Result pagination: Optional limit parameter with truncation info
• Graceful shutdown: Drains all pools on SIGTERM/SIGINT

Documentation

• README with setup, config, and usage examples
• SECURITY.md with defense-in-depth architecture
• CONTRIBUTING.md with dev guidelines
• CHANGELOG.md

DevOps

• GitHub Actions CI/CD (Node 18/20/22)
• Dockerfile for container deployment
• ESLint + Prettier
• 52 vitest tests
• TypeScript source maps