Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,314
pages available: 180

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 browser

Browse databases skills

Showing 4,201–4,224 of 4,314 skills

Neon InstagresAInstantly 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.databasesjavascripttypescriptVotes: 0GitHub stars: 30,495
Transaction ManagementAManage database transactions for data consistency. Use when implementing ACID compliance, handling concurrency, or managing transaction isolation levels.databasesjavascriptjavaVotes: 0GitHub stars: 327
Stored ProceduresAImplement stored procedures and functions for database logic. Use when creating reusable database routines, complex queries, or server-side calculations.databasessqltestingVotes: 0GitHub stars: 327
Sql Query OptimizationAAnalyze and optimize SQL queries for performance. Use when improving slow queries, reducing execution time, or analyzing query performance in PostgreSQL and MySQL.databasesgosqlVotes: 0GitHub stars: 327
Spring Boot ApplicationABuild 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.databasesjavasqlVotes: 0GitHub stars: 327
Ruby Rails ApplicationADevelop 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.databasesrustgoVotes: 0GitHub stars: 327
Query Caching StrategiesAImplement query caching strategies to improve performance. Use when setting up caching layers, configuring Redis, or optimizing database query response times.databasesjavascriptgoVotes: 0GitHub stars: 327
Nosql Database DesignADesign NoSQL database schemas for MongoDB and DynamoDB. Use when modeling document structures, designing collections, or planning NoSQL data architectures.databasesjavascriptgoVotes: 0GitHub stars: 327
Idempotency HandlingAImplement 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.databasestypescriptpythonVotes: 0GitHub stars: 327
Flask Api DevelopmentADevelop 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.databasespythonrustVotes: 0GitHub stars: 327
Event SourcingAImplement event sourcing and CQRS patterns using event stores, aggregates, and projections. Use when building audit trails, temporal queries, or systems requiring full history.databasestypescriptsqlVotes: 0GitHub stars: 327
Database ShardingAImplement database sharding for horizontal scalability. Use when scaling large databases, distributing data across multiple servers, or designing sharded architectures.databasesgosqlVotes: 0GitHub stars: 327
Database Schema DocumentationADocument database schemas, ERD diagrams, table relationships, indexes, and constraints. Use when documenting database schema, creating ERD diagrams, or writing table documentation.databasesgobashVotes: 0GitHub stars: 327
Database Schema DesignADesign database schemas with normalization, relationships, and constraints. Use when creating new database schemas, designing tables, or planning data models for PostgreSQL and MySQL.databasessqlrailsVotes: 0GitHub stars: 327
Database Performance DebuggingADebug database performance issues through query analysis, index optimization, and execution plan review. Identify and fix slow queries.databasespythongoVotes: 0GitHub stars: 327
Database MonitoringAMonitor database performance and health. Use when setting up monitoring, analyzing metrics, or troubleshooting database issues.databasessqlgitVotes: 0GitHub stars: 327
Database Migration ManagementAManage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations in PostgreSQL and MySQL.databasespythongoVotes: 0GitHub stars: 327
Database Indexing StrategyADesign and implement database indexing strategies. Use when creating indexes, choosing index types, or optimizing index performance in PostgreSQL and MySQL.databasesgosqlVotes: 0GitHub stars: 327
Database Backup RestoreAImplement backup and restore strategies for disaster recovery. Use when creating backup plans, testing restore procedures, or setting up automated backups.databasesgobashVotes: 0GitHub stars: 327
Data Replication SetupBSet up database replication for high availability and disaster recovery. Use when configuring master-slave replication, multi-master setups, or replication monitoring.databasesgobashVotes: 0GitHub stars: 327
Data Migration ScriptsACreate 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.databasestypescriptpythonVotes: 0GitHub stars: 327
Backup Disaster RecoveryBImplement backup strategies, disaster recovery plans, and data restoration procedures for protecting critical infrastructure and data.databasesbashsqlVotes: 0GitHub stars: 327
Api Filtering SortingAImplement 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.databasesjavascriptpythonVotes: 0GitHub stars: 327
Keyword ResearchAUse when expanding seed topics into intent-based clusters and prioritizingdatabasesVotes: 0GitHub stars: 396