PostgreSQL in production: queries, indexes, migrations without downtime, pooling and the traps that only show on PostgreSQL.
0 on GitHubby Rene Roscherv0.1.0Apache-2.0updated 5 days agodatabase
/
Plugin data from marketplace rene-roscher-skills in Rene-Roscher/skills. Commands read from the repo's manifest — 5 days ago.
What it installs
Skills (1)
postgres-production
Decides how application code and migrations talk to PostgreSQL in production: parameterised queries, keyset pagination, index design, zero-downtime DDL with lock_timeout and NOT VALID, batched backfills, savepoints and retries, pooler limits, timestamptz, EXPLAIN. Use when writing PostgreSQL queries
Goal focus, work on smaller models, a glossary of EU and German ecosystem terms, subagent delegation, hand-off specs for executor models, evidence before claims, verification, safe actions, project inception, scaffolding from official starters, planning, delivery, tests, maintainable code, lessons, tooling, commits, stack bootstrap, performance, security assurance. Stack-agnostic.
Multi-tenant B2B SaaS: tenancy model, domain design and events, localization, external IDs, isolation, RBAC, plan entitlements, build vs buy, EU B2B billing, GDPR, EU and German legal baseline, service boundaries, async jobs, egress and webhooks.
Infrastructure as code, Kubernetes workloads, edge proxy and TLS, observability and DR, and failover for DNS, mail, hosting, PostgreSQL and object storage.
Editorial diagrams in your brand, as self-contained HTML and SVG. Architecture, flowcharts, sequence, state machines, ER and database schemas, timelines, swimlanes, org charts, Gantt, Wardley maps, user journeys, service blueprints, UML class, lifecycle phase maps, and charts from bar, line and scatter to Sankey, treemap and heatmap, plus many more. Redraws draw.io, Mermaid, Excalidraw and PlantUML files. Exports SVG and PNG.
Query Trackio projects, runs, and metrics using the `trackio` CLI. Use when the user needs to list projects/runs/metrics, get summaries, or retrieve metric values from local Trackio databases. Supports both human-readable and JSON output formats. Covers project discovery, run inspection, metric querying, and system metrics. Designed for LLM agents and automation scripts.
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database clusters. This plugin provides 14 tools across two active MCP backends (self-hosted MCP Toolbox and managed CockroachDB Cloud MCP Server), three specialized agents (DBA, Developer, Operator), 32 skills across 6 operational domains, and built-in safety hooks.
Payload Development plugin - covers collections, fields, hooks, access control, plugins, and database adapters.
1 skill
payloadcms/payload 45,796
Maintain data?
This page updates itself from your repo. Add the badge to your README, or get it Featured to pin it above the organic results with a followed link to your site.