What's New
🧬 pgvector Health Checks
New pgvector CLI subcommand and pg_dash_pgvector MCP tool:
pg-dash pgvector postgres://...- Checks pgvector installation and version
- Lists vector columns with dimension analysis (flags >2000d)
- Analyzes vector index types (IVFFlat vs HNSW) with parameter tuning
- IVFFlat
listsvalidation against row count (should be ~√rows) - HNSW
ef_constructionvsmratio check - Detects missing vector indexes on large tables
- Index size vs table size ratio warnings
🌐 MCP Streamable HTTP Transport
pg-dash MCP server now supports remote deployment as a shared team server:
# Run as HTTP server (stateless, MCP 2026-07-28 compatible)
pg-dash-mcp postgres://... --http
# Custom port
MCP_PORT=9000 pg-dash-mcp postgres://... --httpUses Hono + Web Standard StreamableHTTPServerTransport, compatible with the upcoming MCP 2026-07-28 stateless protocol spec.
Other Changes
- MCP tools count: 25 → 26
- Updated README with SQL safety section and pgvector documentation