Databases

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

skills in category: 4,708
pages available: 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 browser

Browse databases skills

Showing 4,585–4,608 of 4,708 skills

PostgresqlADesign a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced featuresdatabasesgosqlVotes: 0GitHub stars: 45,825
Database OptimizerAExpert database optimizer specializing in modern performancedatabasesgosqlVotes: 0GitHub stars: 45,825
Database Migrations Sql MigrationsASQL database migrations with zero-downtime strategies fordatabasesgobashVotes: 0GitHub stars: 45,825
Text To SqlAConvert natural language queries to SQL. Use for database queries, data analysis, and reporting.databasesbashsqlVotes: 0GitHub stars: 40
Uspto DatabaseAAccess USPTO APIs for patent/trademark searches, examination history (PEDS), assignments, citations, office actions, TSDR, for IP analysis and prior art searches.databasespythongoVotes: 0GitHub stars: 40
Nosql ExpertAExpert 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.databasesgosqlVotes: 0GitHub stars: 30,495
Neon PostgresAExpert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.databasesdatabaseVotes: 0GitHub stars: 30,495
Gnomad FrequenciesAQuery 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.databasespythongoVotes: 0GitHub stars: 1,198
Molecular IoAReads, 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.databasespythondatabaseVotes: 0GitHub stars: 1,198
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