mirelconstantin/dsh-postgres-expert
PostgreSQL expertise for DeepSeek Harness: eleven curated skills from Tiger Data's pg-aiguide registered as native skills (table and spatial design, schema exploration, zero-downtime migrations, pgvector semantic search, hybrid BM25+semantic search, TimescaleDB hypertables and hyperfunctions) plus the public pg-aiguide MCP server for version-exact manual search — so the model stops writing 2015-era schemas from memory.
dsh-postgres-expert gives DeepSeek Harness PostgreSQL expertise using eleven curated skills from Tiger Data's pg-aiguide, registered as native skills, plus the public pg-aiguide MCP server for version-exact manual search. The skills cover an umbrella router, relational table design, PostGIS spatial design, read-only schema exploration through pg_catalog, zero-downtime migration, pgvector semantic search, PostgreSQL hybrid text search (BM25 + semantic fused with RRF), TimescaleDB hypertable setup, hypertable-candidate discovery, in-place vs blue-green table migration and TimescaleDB hyperfunctions. The harness routes to the right skill from each skill's description before the model decides anything, so the model stops writing 2015-era schemas from memory.
Install
dsh plugin add dsh-postgres-expertCopied verbatim from the README's Install block ('Or from a terminal'). The README notes it is a plain npm install, needs neither git nor a GitHub account, has no build step, and that a GUI 'Add plugin' path (dsh-postgres-expert) and a pinned form (dsh plugin add dsh-postgres-expert@1.0.0) also exist.
Compatibility
Needs a DeepSeek Harness profile and nothing else — no API key, database or account — because the only network call is an optional documentation search against a public endpoint. Three rows appear after restart: postgres-expert-skills (registers 11 vendored skills), postgres-expert-prompt (system-prompt section) and postgres-expert-mcp (the public pg-aiguide MCP server over Streamable HTTP). postgres-expert-mcp is the only row that touches the network, so disabling it leaves the curated skills working entirely offline.
Details
- Repo: mirelconstantin/dsh-postgres-expert
- Category: Tools & Capabilities
- Stars: 1
- Version: GitHub repo mirelconstantin/dsh-postgres-expert; npm package dsh-postgres-expert at 1.0.1 (registry check 2026-10-10; registry repository field resolves back to this repo). Apache-2.0 license; Node >=22.19.
Alternatives
akash-digitavision/dsh-serena · 6Mikao9/dsh-wsl-workspace · AbnerAI/dsh-monitor