Database Schema & Query Optimizer

from meowkit15

Reference-backed guidance for database design, migrations, and query optimization (PostgreSQL primary).

triggers:database schemamigrationsql optimizationindexingN+1 query

Comprehensive support for relational database engineering with a primary focus on PostgreSQL:

Schema Design: Expert guidance on normalization, naming conventions, and anti-pattern avoidance (e.g., EAV).
Safe Migrations: Planning zero-downtime migrations with mandatory 'up' and 'down' scripts and locking awareness.
Query Optimization: Detecting N+1 problems, proposing efficient indexing strategies, and analyzing execution plans via EXPLAIN ANALYZE.
Security First: Enforces parameterized queries to prevent SQL injection.

Includes specific 'gotchas' for PostgreSQL versioning and concurrency control.

Not yet audited

This skill has not been reviewed by our automated audit pipeline yet.

Information

Repository: meowkit
Stars: 15

More from meowkit

MeowKit Design

Design guidelines, assets and UI kits for MeowKit — produce branded interfaces, prototypes, and HTML artifacts tailored for Claude Code agents.

MeowKit Strategic Problem Solving

Strategic 'unsticking' framework using 7 non-default cognitive techniques to overcome approach blocks and design flaws.

MeowKit Navigation Help

Workflow navigation assistant that scans project state and recommends the next step in a 7-phase development pipeline.

Related Skills

Sync Production Database to Development

Run a safe, scripted workflow to download production database dumps and restore them into a development environment (download-only and restore options).

FastAPI Project Templates

Creates production-ready FastAPI project scaffolds with async patterns, DI, middleware, and testing best practices for high-performance APIs.

SSE Stream Resilience

Provide robust server-sent-events (SSE) stream management with Redis-backed registry, heartbeat monitoring, completion persistence, and background guardian clea

Payment Gateway Integration

Guides and code for integrating major payment providers (Stripe, PayPal, Square) with backend systems: payment intents, subscriptions, webhook handling, and PCI

Dune Analytics (MoonPay Integration)

Run Dune SQL and saved queries via the Dune REST API for on-chain analytics; pairs with MoonPay CLI to create/fund wallets for analysis.

Common API Design Standards

Opinionated REST API design guidelines: HTTP semantics, status codes, URL design, versioning, pagination, and OpenAPI contract best-practices.

MetricFlow: Interactive Metric Definition

Interactively define MetricFlow metrics from natural-language business descriptions; proposes, validates, and dry-runs metric YAML for semantic modeling.

API Development

Guidelines and patterns for building robust REST APIs: correct HTTP status codes, RFC 7807 error responses, validation, sanitization, rate limiting, and central

Database Schema & Query Optimizer