agentrigs
+ submit rig
~ / rigs / timescale / pg-aiguide

timescale/pg-aiguide

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

↗ GitHub ★ 1,854 apache-2.0 updated 8d ago project Claude Code
share on X
ARCHETYPE
Skill Collector
Ten-plus skills loaded on demand. A procedural-knowledge library.
CONTEXT TAX · EVERY TURN
~3.3k tokens
Moderate · median rig: 2.3k · breakdown
GUARDRAILS
0/5
No committed guardrails · details

Copy this rig

# review before running: this installs third-party code
$ claude mcp add --transport http pg-aiguide 'https://mcp.tigerdata.com/docs?disable_mcp_skills=1'
$ npx degit timescale/pg-aiguide/skills ./rig-pg-aiguide/skills

MCP servers are added to Claude Code at local scope; env vars are shown as YOUR_… placeholders — we never store values. Files are fetched with degit into a separate folder so you can review before merging.

$ claude mcp add --transport http pg-aiguide 'https://mcp.tigerdata.com/docs?disable_mcp_skills=1'
$ npx degit timescale/pg-aiguide/skills/design-postgis-tables .claude/skills/design-postgis-tables
$ npx degit timescale/pg-aiguide/skills/design-postgres-tables .claude/skills/design-postgres-tables
$ npx degit timescale/pg-aiguide/skills/find-hypertable-candidates .claude/skills/find-hypertable-candidates
$ npx degit timescale/pg-aiguide/skills/migrate-postgres-tables-to-hypertables .claude/skills/migrate-postgres-tables-to-hypertables
$ npx degit timescale/pg-aiguide/skills/pgvector-semantic-search .claude/skills/pgvector-semantic-search
$ npx degit timescale/pg-aiguide/skills/postgres-database-migration .claude/skills/postgres-database-migration
$ npx degit timescale/pg-aiguide/skills/postgres-hybrid-text-search .claude/skills/postgres-hybrid-text-search
$ npx degit timescale/pg-aiguide/skills/postgres .claude/skills/postgres
$ npx degit timescale/pg-aiguide/skills/schema-exploration .claude/skills/schema-exploration
$ npx degit timescale/pg-aiguide/skills/setup-timescaledb-hypertables .claude/skills/setup-timescaledb-hypertables
$ npx degit timescale/pg-aiguide/skills/timescaledb-hyperfunctions .claude/skills/timescaledb-hyperfunctions

This rig commits no guardrails. Here is the community baseline instead — the deny/ask rules most often found across all 7,204 rigs:

{
  "permissions": {
    "deny": [
      "Read(./.env)",
      "Read(**/.env)",
      "Read(~/.ssh/**)",
      "Bash(rm -rf *)",
      "Read(**/*.pem)",
      "Bash(rm -rf /)",
      "Bash(git push --force:*)",
      "Bash(sudo *)",
      "Read(.env)",
      "Bash(rm -rf /*)",
      "Read(./.env.*)",
      "Read(~/.aws/**)",
      "Bash(git push --force*)",
      "Bash(rm -rf:*)",
      "Read(**/*.key)",
      "Read(**/.env.*)",
      "Bash(sudo:*)",
      "Bash(git reset --hard*)",
      "Bash(git reset --hard:*)",
      "Read(.env.*)"
    ],
    "ask": [
      "Bash(git push:*)",
      "Bash(git push *)",
      "Bash(git commit:*)",
      "Bash(rm *)",
      "Bash(rm:*)",
      "Bash(git rebase *)",
      "Bash(wget *)",
      "Bash(npm publish:*)",
      "Bash(git commit *)",
      "Bash(gh pr merge *)"
    ]
  }
}

MCP servers (1)

serversourceest. tokens
mcp.tigerdata.com · "pg-aiguide" remote · remote 2.5k

Skills (11)

design-postgis-tablesdesign-postgres-tablesfind-hypertable-candidatesmigrate-postgres-tables-to-hypertablespgvector-semantic-searchpostgres-database-migrationpostgres-hybrid-text-searchpostgresschema-explorationsetup-timescaledb-hypertablestimescaledb-hyperfunctions

Similar rigs

Idun-Group/idun-agent-platform
🟪 Open-source runtime that ships any LangGraph or Google ADK agent as a production-ready FastAPI service. Bundled , AG-UI copilotkit API, chat UI, 15+ guardrails, MCP, OpenTelemetry, OIDC. One pip install. Self-hosted, no vendor lock-in.
★ 203 project Claude CodeCursor 2 skills 1 agents 17d ago
Pragmatist 10.7k tok ·
CodelyTV/agentic_programming-course
Agentic Programming with AI: Practical Fundamentals course examples
★ 38 project CodexCursorCopilot 1 mcp 10 skills 6mo ago
Skill Collector 2.1k tok ·
base58ed/claude_code_files
Select files from my claude-code config.
★ 1 project Claude Code 18 skills 2mo ago
Skill Collector 3.4k tok ·
langchain-ai/deepagents
The batteries-included agent harness.
★ 30.0k collection Codex 2 mcp 20 skills 3d ago
Skill Collector 9.8k tok ·
copied ✓