Postgres Schema Toolkit
Curated

Postgres Schema Toolkit

Covers schema design, query drafting, and SQL tuning for relational backends. Best for agents working on data-heavy features that need clean modeling and fast access.

3 skills 1 installs
postgresqlsqldatabaseschema-designoptimization
Updated today

Install

Run this command to install all skills in this plugin:

npx skillstore add @postgres-schema-query-toolkit

Skills will be installed to .claude/skills/ directory

Overview

Usage Guide

Enhanced by AI

Detailed Guide

## Overview
Postgres Schema Toolkit bundles three Supabase-approved skills that walk you from a blank PostgreSQL database to fast, well-modeled queries. Use it when an agent is shipping data-heavy features that need clean relational modeling, accurate SQL, and tuned access paths.

## Quick Start
1. Install the plugin in your OpenClaw workspace.
2. Sketch your domain and call **postgresql-table-design** to lay out tables, data types, constraints, and indexes following PostgreSQL best-practices.
3. Use **query-builder** interactively to draft optimized SQL (or NoSQL) queries against the new schema, then run **query-optimizer** to analyze and tighten them for better performance and efficiency.

## Key Commands
- `postgresql-table-design` — Design a PostgreSQL-specific schema with appropriate data types, indexing, constraints, and advanced performance patterns.
- `query-builder` — Interactive database query builder for generating optimized SQL and NoSQL queries that match the intended access pattern.
- `query-optimizer` — Analyze and optimize SQL queries for better performance and fewer bottlenecks.

## Tips
- Always run query-optimizer after query-builder produces a candidate query — the analyzer surfaces missing indexes that feed straight back into postgresql-table-design.
- Pair this plugin with a migrations or ORM-focused plugin so the table-design output lands as versioned schema changes rather than ad-hoc DDL.
- Capture the EXPLAIN output from query-optimizer in your PR description so reviewers see the before/after access plan.

Skills

3