All categories
Databases
SQL, NoSQL, schema design, migrations, ORMs, and database operations
- 5,632
- 235
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 5,521–5,544 of 5,632 skills
- Nosql ExpertExpert guidance for distributed NoSQL databases (Cassandra, DynamoDB). Focuses on mental models, query-first modeling, single-table design, and avoiding hot partitions in high-scale systems.Votes: 0GitHub stars: 33,322
- Neon PostgresExpert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.Votes: 0GitHub stars: 33,322
- Gnomad FrequenciesQuery gnomAD for population allele frequencies to assess variant rarity. Use when filtering variants by population frequency for rare disease analysis or determining if a variant is common in the general population.Votes: 0GitHub stars: 1,198
- Molecular IoReads, writes, and converts molecular file formats (SMILES, SDF, MOL2, PDB) using RDKit and Open Babel. Handles structure parsing, canonicalization, and full standardization pipeline including sanitization, normalization, and tautomer canonicalization. Use when loading chemical libraries, converting formats, or preparing molecules for analysis.Votes: 0GitHub stars: 1,198
- Supabase Postgres Best PracticesPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.Votes: 0GitHub stars: 33,322
- Neon InstagresInstantly provision production-ready Postgres databases with Neon Instagres. Use when setting up databases, when users mention PostgreSQL/Postgres, database setup, or need a development database. Works with Drizzle, Prisma, raw SQL.Votes: 0GitHub stars: 33,322
- Transaction ManagementManage database transactions for data consistency. Use when implementing ACID compliance, handling concurrency, or managing transaction isolation levels.Votes: 0GitHub stars: 327
- Stored ProceduresImplement stored procedures and functions for database logic. Use when creating reusable database routines, complex queries, or server-side calculations.Votes: 0GitHub stars: 327
- Sql Query OptimizationAnalyze and optimize SQL queries for performance. Use when improving slow queries, reducing execution time, or analyzing query performance in PostgreSQL and MySQL.Votes: 0GitHub stars: 327
- Spring Boot ApplicationBuild enterprise Spring Boot applications with annotations, dependency injection, data persistence, REST controllers, and security. Use when developing Spring applications, managing beans, implementing services, and configuring Spring Boot projects.Votes: 0GitHub stars: 327
- Rag QdrantHigh-performance vector similarity search engine for RAG and semantic search. Use when building production RAG systems requiring fast nearest neighbor search, hybrid search with filtering, or scalable vector storage with Rust-powered performance.Votes: 0GitHub stars: 33,322
- Ruby Rails ApplicationDevelop Ruby on Rails applications with models, controllers, views, Active Record ORM, authentication, and RESTful routes. Use when building Rails applications, managing database relationships, and implementing MVC architecture.Votes: 0GitHub stars: 327
- Query Caching StrategiesImplement query caching strategies to improve performance. Use when setting up caching layers, configuring Redis, or optimizing database query response times.Votes: 0GitHub stars: 327
- Nosql Database DesignDesign NoSQL database schemas for MongoDB and DynamoDB. Use when modeling document structures, designing collections, or planning NoSQL data architectures.Votes: 0GitHub stars: 327
- Idempotency HandlingImplement idempotency keys and handling to ensure operations can be safely retried without duplicate effects. Use when building payment systems, APIs with retries, or distributed transactions.Votes: 0GitHub stars: 327
- Flask Api DevelopmentDevelop lightweight Flask APIs with routing, blueprints, database integration, authentication, and request/response handling. Use when building RESTful APIs, microservices, or lightweight web services with Flask.Votes: 0GitHub stars: 327
- Event SourcingImplement event sourcing and CQRS patterns using event stores, aggregates, and projections. Use when building audit trails, temporal queries, or systems requiring full history.Votes: 0GitHub stars: 327
- Database ShardingImplement database sharding for horizontal scalability. Use when scaling large databases, distributing data across multiple servers, or designing sharded architectures.Votes: 0GitHub stars: 327
- Database Schema DocumentationDocument database schemas, ERD diagrams, table relationships, indexes, and constraints. Use when documenting database schema, creating ERD diagrams, or writing table documentation.Votes: 0GitHub stars: 327
- Database Schema DesignDesign database schemas with normalization, relationships, and constraints. Use when creating new database schemas, designing tables, or planning data models for PostgreSQL and MySQL.Votes: 0GitHub stars: 327
- Database Performance DebuggingDebug database performance issues through query analysis, index optimization, and execution plan review. Identify and fix slow queries.Votes: 0GitHub stars: 327
- 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