design-postgres-tables
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features
Découvrez les skills blockchain sql databases, comparez leurs dépôts et consultez leurs instructions.
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features
Use this skill when you need to alter the PocketBase database schema - creating, updating, or deleting collections. Never write migration SQL by hand.
Evidence framework data dashboard with DuckDB. Write SQL in markdown to create visualizations.
Presentation-focused Natural Language to SQL app with PPT-style visualizations.
Chat app that lets you ask questions in plain English and query your PostgreSQL database.
Write type-safe Kysely queries following project patterns. Use when writing new database queries, optimizing queries, or working with the @packages/db/src/queries/* files.
Writes database schema specifications using Mermaid ER diagrams and defines table structures for multi-tenant entities. Use when designing database schemas, creating entity-relationship diagrams, or specifying...
Database schema specification using Mermaid ER diagrams, table structures, constraints, and indexes for multi-tenant applications.
Create Laravel database migrations following conventions for schema changes, indexes, and foreign keys. Use when creating migrations, modifying database schema, adding tables, or when user mentions migrations,...
Manage database operations, migrations, RLS policies, and performance optimization
Use when writing raw SQL with GRDB, complex joins across 4+ tables, window functions, ValueObservation for reactive queries, or dropping down from SQLiteData for performance. Direct SQLite access for iOS/macOS...
Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
Define and structure database models and entities following data modeling best practices. Use this skill when creating or modifying model classes, entities, or database schema definitions. Use this skill when d...
Create and manage database migrations following best practices for safe schema evolution. Use this skill when creating new database migration files for schema changes. Use this skill when modifying table struct...
Write secure, performant database queries following best practices for data retrieval and manipulation. Use this skill when writing SQL queries, ORM query methods, or database query builders. Use this skill whe...
Generate production-ready Row Level Security (RLS) policies for Supabase tables with is_super_admin() bypass, proper USING/WITH CHECK, and common relationship patterns; use when creating RLS policies, securing...
Master MongoDB ACID transactions for multi-document operations. Learn session management, transaction mechanics, error handling, and production patterns. Guarantee data consistency across multiple operations.
Master MongoDB schema design and data modeling patterns. Learn embedding vs referencing, relationships, normalization, and schema evolution. Use when designing databases, normalizing data, or optimizing queries...
Master MongoDB indexing and query optimization. Learn index types, explain plans, performance tuning, and query analysis. Use when optimizing slow queries, analyzing performance, or designing indexes.
SQL database querying, optimization, and data management for analytics
Master relational and NoSQL databases. Learn PostgreSQL, MySQL, MongoDB, Redis, and other technologies for data persistence, optimization, and scaling.
Master Redis transactions - MULTI/EXEC, WATCH for optimistic locking, Lua scripting, and atomic operation patterns
Master PostgreSQL SQL fundamentals - data types, tables, constraints, schema design
Master advanced PostgreSQL queries - CTEs, window functions, recursive queries
Le classement utilise les étoiles du dépôt GitHub indexé. Plusieurs skills peuvent partager ce nombre : ce n’est ni un nombre d’installations ni une note de qualité.