All categories
Databases
SQL, NoSQL, schema design, migrations, ORMs, and database operations
- 4,708
- 197
Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.
Open in full browserBrowse databases skills
Showing 4,609–4,632 of 4,708 skills
- Database MonitoringMonitor database performance and health. Use when setting up monitoring, analyzing metrics, or troubleshooting database issues.Votes: 0GitHub stars: 327
- Database Migration ManagementManage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations in PostgreSQL and MySQL.Votes: 0GitHub stars: 327
- Database Indexing StrategyDesign and implement database indexing strategies. Use when creating indexes, choosing index types, or optimizing index performance in PostgreSQL and MySQL.Votes: 0GitHub stars: 327
- Database Backup RestoreImplement backup and restore strategies for disaster recovery. Use when creating backup plans, testing restore procedures, or setting up automated backups.Votes: 0GitHub stars: 327
- Data Replication SetupSet up database replication for high availability and disaster recovery. Use when configuring master-slave replication, multi-master setups, or replication monitoring.Votes: 0GitHub stars: 327
- Data Migration ScriptsCreate safe, reversible database migration scripts with rollback capabilities, data validation, and zero-downtime deployments. Use when changing database schemas, migrating data between systems, or performing large-scale data transformations.Votes: 0GitHub stars: 327
- Backup Disaster RecoveryImplement backup strategies, disaster recovery plans, and data restoration procedures for protecting critical infrastructure and data.Votes: 0GitHub stars: 327
- Api Filtering SortingImplement advanced filtering and sorting capabilities for APIs with query parsing, field validation, and optimization. Use when building search features, complex queries, or flexible data retrieval endpoints.Votes: 0GitHub stars: 327
- Keyword ResearchUse when expanding seed topics into intent-based clusters and prioritizingVotes: 0GitHub stars: 396
- Signal TaxonomyUse to define schemas, topic tags, and lineage metadata for enrichedVotes: 0GitHub stars: 396
- Supabase AdminSupabase administration, RLS policies, migrations, and schema design. Use for database architecture, Row Level Security, performance tuning, auth integration. Activate on "Supabase", "RLS", "migration", "policy", "schema", "auth.uid()". NOT for Supabase Auth UI configuration (use dashboard), edge functions (use cloudflare-worker-dev), or general SQL without Supabase context.Votes: 0GitHub stars: 208
- Postgresql OptimizationExpert in PostgreSQL performance tuning, query optimization, and database administration. Specializes in EXPLAIN analysis, indexing strategies, connection pooling, partitioning, and production-grade PostgreSQL operations.Votes: 0GitHub stars: 208
- Large Scale Map VisualizationMaster of high-performance web map implementations handling 5,000-100,000+ geographic data points. Specializes in Leaflet.js optimization, Supercluster algorithms, viewport-based loading, canvas rendering, and progressive disclosure UX patterns.Votes: 0GitHub stars: 208
- Geospatial Data PipelineProcess, analyze, and visualize geospatial data at scale. Handles drone imagery, GPS tracks, GeoJSON optimization, coordinate transformations, and tile generation. Use for mapping apps, drone data processing, location-based services. Activate on "geospatial", "GIS", "PostGIS", "GeoJSON", "map tiles", "coordinate systems". NOT for simple address validation, basic distance calculations, or static map embeds.Votes: 0GitHub stars: 208
- Drizzle MigrationsManage database schema with Drizzle ORM and SQLite migrations. Use when adding tables, modifying columns, creating indexes, or running migrations. Activates for database schema changes, migration generation, and Drizzle query patterns.Votes: 0GitHub stars: 208
- Similarity Search PatternsImplement efficient similarity search with vector databases. Use when building semantic search, implementing nearest neighbor queries, or optimizing retrieval performance.Votes: 0GitHub stars: 40,199
- Sql Optimization PatternsMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.Votes: 0GitHub stars: 40,199
- Projection PatternsBuild read models and projections from event streams. Use when implementing CQRS read sides, building materialized views, or optimizing query performance in event-sourced systems.Votes: 0GitHub stars: 40,199
- Event Store DesignDesign and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.Votes: 0GitHub stars: 40,199
- Prisma 7Use when working with database schema, migrations, queries, or relations via Prisma 7 (Rust-free client, TypedSQL, Omit API).Votes: 0GitHub stars: 29
- Laravel MigrationsUse when designing a database schema or managing Laravel 13 migrations — Schema Builder, columns, indexes, foreign keys, or seeders.Votes: 0GitHub stars: 29
- Laravel EloquentUse when working with database models — Eloquent ORM, PHP attributes, relationships, queries, observers, or factories in Laravel 13.Votes: 0GitHub stars: 29
- Sql Executor对SQLite、PostgreSQL、MySQL数据库执行SQL查询，支持结果格式化和导出。Votes: 0GitHub stars: 85
- TimescaledbMANDATORY when working with time-series data, hypertables, continuous aggregates, or compression - enforces TimescaleDB 2.24.0 best practices including lightning-fast recompression, UUIDv7 continuous aggregates, and Direct CompressVotes: 0GitHub stars: 11