PostgreSQL Optimization
Independent PiSkill directory guide. The original skill remains hosted by GitHub Awesome Copilot.
What is PostgreSQL Optimization?
Analyzes PostgreSQL queries and schema evidence to improve indexes, execution plans, statistics, joins, filtering, storage, and workload-specific performance.
Compatible tools
Related skills
Supabase Postgres Best Practices
Reviews PostgreSQL schemas and queries for indexing, constraints, security, data access, connection management, and performance practices relevant to Supabase projects.
PostgreSQL Code Review
Reviews PostgreSQL migrations, functions, queries, indexes, permissions, and transaction behavior for correctness, maintainability, security, and performance risks.
Cloud Firestore Development
Designs and implements Cloud Firestore data models, queries, indexes, transactions, realtime listeners, emulator tests, and security-aware access patterns.
Firebase Data Connect
Builds Firebase Data Connect backends with schema, operations, generated SDKs, authentication context, local tooling, deployment, and query validation.
AlloyDB Fundamentals
Guides AlloyDB setup and operational work across instances, connectivity, PostgreSQL compatibility, performance, security, backups, and common administration tasks.
Azure PostgreSQL for TypeScript
Builds TypeScript applications against Azure Database for PostgreSQL with authentication, connections, queries, pooling, configuration, error handling, and deployment concerns.