sql-databases
0
database-design
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
seanpham99
databases
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
sql-databases
0
cost-supabase
Estimate Supabase costs for any project using live pricing data. Use when user asks about Supabase pricing, BaaS costs, or PostgreSQL-based backend costs.
bnayae
databases
sql-databases
0
postgis-spatial
Use when working with geographic queries, geometry filtering, ST_* functions, or region-based candidate filtering. Load for PostGIS spatial operations, polygon intersections, distance calculations, or geographic bounds. Covers ST_Intersects, ST_Contains, GiST indexes, and geometry storage patterns.
discountedcookie
databases
sql-databases
0
db-bandwidth-optimization
Tối ưu Database Bandwidth và Cloud Costs để tránh bill shock. Sử dụng khi: (1) Review code có query database, (2) Phát hiện N+1 problem, (3) Tối ưu queries chậm, (4) Giảm cloud costs, (5) User hỏi về database performance, bandwidth, query optimization, hoặc khi thấy patterns như .collect(), .findAll(), fetch all then filter. CRITICAL: Sử dụng skill này TRƯỚC KHI deploy để tránh thảm họa tài chính.
Hieubkav
databases
sql-databases
0
preventing-sql-injection
Prevent SQL injection by using $queryRaw tagged templates instead of $queryRawUnsafe. Use when writing raw SQL queries or dynamic queries.
djankies
databases
sql-databases
0
agentuity-cli-cloud-db-sql
Execute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations
agentuity
databases
sql-databases
0
database-locking-strategies
Understanding and implementing database locking mechanisms for concurrency control.
AmnadTaowsoam
databases
sql-databases
0
database-migrations
Database migration patterns for Supabase, Prisma, and Drizzle ORM. Best practices for schema changes, rollbacks, and production deployments. Use when managing database schema evolution in production applications.
Naw3
databases
sql-databases
0
backend-models
Define database models and schemas with proper naming, data types, constraints, relationships, and indexing strategies. Use this skill when creating or modifying database models, entity definitions, or schema files. When working on files like models.py, models/*.ts, entities/*.ts, schema.prisma, or ORM model definitions. When defining table structures, setting up foreign key relationships, adding database constraints (NOT NULL, UNIQUE), choosing appropriate data types, or implementing model-level validation.
mshafei721
databases
sql-databases
0
sqlalchemy
SQLAlchemy Python SQL toolkit and ORM. Use for database models, queries, sessions, relationships, migrations, async database operations, and working with PostgreSQL, MySQL, SQLite, Oracle, SQL Server.
joneqian
databases
sql-databases
0
orm-patterns
ORM usage patterns, best practices for Prisma and Drizzle, and when to use ORMs vs raw SQL
Lordsisodia
databases
sql-databases
0
agentuity-cli-cloud-db-logs
Get query logs for a specific database. Requires authentication. Use for Agentuity cloud platform operations
agentuity
databases
sql-databases
0
php-symfony-doctrine-fetch-modes
Optimize Doctrine queries with fetch modes, eager loading, lazy loading, and query hints. WHEN: Fixing N+1 queries, configuring eager/lazy loading, using EXTRA_LAZY collections, optimizing query performance, adding fetch joins. WHEN NOT: Batch processing large datasets (use php-symfony-doctrine-batch-processing), migrations (use php-symfony-doctrine-migrations).
LounisBou
databases
sql-databases
0
readathon-database-safety
Warn and protect against dangerous database operations on production database in the readathon project
stevensouza
databases
sql-databases
0
database-design
数据库设计指南。当用户需要设计数据库 Schema、优化索引、规划表结构、处理数据关系或进行数据库性能优化时使用此技能。
enoch-robinson
databases
sql-databases
0
sqlmodel-task-models
This skill should be used when defining a robust, type-safe, and async-compatible database schema for the Todo application using SQLModel, ensuring compatibility with Better Auth and optimized for PostgreSQL.
SyedaNabila559
databases
sql-databases
0
database-management
Handles database schema design, Drizzle ORM queries, and Expo SQLite migrations.
yunuskorkmaz
databases
sql-databases
0
moai-platform-supabase
Supabase specialist covering PostgreSQL 16, pgvector, RLS, real-time subscriptions, and Edge Functions. Use when building full-stack apps with Supabase backend.
zellycloud
databases
sql-databases
0
verify-sql
Validates SQL statements before execution using comprehensive dry-run checks to catch syntax errors, schema mismatches, constraint violations (CHECK, NOT NULL, UNIQUE), foreign key violations, data type mismatches, and runtime errors without modifying the database. CRITICAL - Use this skill BEFORE executing any INSERT/UPDATE/DELETE statements. Use when you need to: (1) Verify SQL will execute successfully before running it, (2) Check foreign key references exist to prevent FK violations, (3) Validate constraint values match CHECK/enum requirements, (4) Test stored procedure calls with parameter validation, or (5) Eliminate trial-and-error debugging loops by catching errors before execution
zohar-ui
databases
