Databases

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

skills in category: 4,700
pages available: 196

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 2,257–2,280 of 4,700 skills

Postgres OptimizationAPostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling. Use when you need help with postgres optimization.databasesgosqlVotes: 0GitHub stars: 8
Pgvector ExpertADeep expertise in pgvector 0.8+ for PostgreSQL — HNSW/IVFFlat tuning, halfvec/sparsevec, hybrid search with tsvector + RRF, and pgvectorscale (DiskANN). Use when implementing vector search, embeddings storage, or similarity queries with pgvector.databasesgosqlVotes: 0GitHub stars: 8
Neon ExpertAExpert in Neon serverless Postgres, branching, autoscaling, and the serverless driver. Use when deploying to or building on neon edge/serverless platform.databasesgobashVotes: 0GitHub stars: 8
Mysql PerformanceAExpert in MySQL database performance optimization, indexing, query tuning, replication, and production best practices. Use when designing, querying, or optimizing mysql databases.databasespythongoVotes: 0GitHub stars: 8
Msft Azure Resource Manager Mysql DotnetA|. Use when you need help with azure resource manager mysql dotnet.databasesbashsqlVotes: 0GitHub stars: 8
Msft Azure Resource Manager Cosmosdb DotnetA|. Use when you need help with azure resource manager cosmosdb dotnet.databasesgobashVotes: 0GitHub stars: 8
Materialize ExpertAExpert in Materialize streaming SQL, sources, sinks, and incremental views. Use when working with materialize for data processing, streaming, or analytics.databasesgosqlVotes: 0GitHub stars: 8
Kafka ExpertAExpert in Kafka 3.x/4.0 with KRaft, exactly-once semantics, and consumer groups. Use when working with kafka for data processing, streaming, or analytics.databasespythongoVotes: 0GitHub stars: 8
Ghcopilot Sql Server Table ReconciliationAUse when: comparing SQL Server tables across instances, data migration validation, ETL verification, row mismatch detection, schema drift, reconciliation report, production vs staging comparison. Uses mssql-python driver with Apache Arrow for fast columnar data transfer and comparison.databasespythonbashVotes: 0GitHub stars: 8
Ghcopilot Sql OptimizationAUniversal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance. Use when you need help with sql optimization.databasesgosqlVotes: 0GitHub stars: 8
Ghcopilot Scaffolding Oracle To Postgres Migration Test ProjectAScaffolds an xUnit integration test project for validating Oracle-to-PostgreSQL database migration behavior in .NET solutions. Creates the test project, transaction-rollback base class, and seed data manager. Use when setting up test infrastructure before writing migration integration tests, or when a test project is needed for Oracle-to-PostgreSQL validation.databasesgoc#Votes: 0GitHub stars: 8
Ghcopilot Reviewing Oracle To Postgres MigrationAIdentifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting, timestamps, concurrent transactions, etc.). Use when planning a database migration, reviewing migration artifacts, or validating that integration tests cover Oracle/PostgreSQL differences.databasessqldatabaseVotes: 0GitHub stars: 8
Ghcopilot Postgresql OptimizationAPostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem. Use when you need help with postgresql optimization.databasesgosqlVotes: 0GitHub stars: 8
Ghcopilot Postgresql Code ReviewAPostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS). Use when you need help with postgresql code review.databasesgosqlVotes: 0GitHub stars: 8
Ghcopilot Migrating Oracle To Postgres Stored ProceduresAMigrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies COLLATE "C" for Oracle-compatible text sorting. Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.databasessqlgitVotes: 0GitHub stars: 8
Ghcopilot Creating Oracle To Postgres Migration Bug ReportACreates structured bug reports for defects found during Oracle-to-PostgreSQL migration. Use when documenting behavioral differences between Oracle and PostgreSQL as actionable bug reports with severity, root cause, and remediation steps.databasessqldatabaseVotes: 0GitHub stars: 8
Event Driven ArchitectureAExpert in event-driven architecture, event sourcing, CQRS, and messaging patterns. Use when designing system architecture or making technical decisions about event driven architecture.databasespythongoVotes: 0GitHub stars: 8
Estuary Flow ExpertAExpert in Estuary Flow real-time CDC captures, collections, and materializations. Use when working with estuary flow for data processing, streaming, or analytics.databasestypescriptgoVotes: 0GitHub stars: 8
Ecc Postgres PatternsAPostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices. Use when you need help with postgres patterns.databasessqlapiVotes: 0GitHub stars: 8
Ecc Laravel TddATest-driven development for Laravel with PHPUnit and Pest, factories, database testing, fakes, and coverage targets. Use when you need help with laravel tdd.databasesphpsqlVotes: 0GitHub stars: 8
Ecc Laravel PatternsALaravel architecture patterns, routing/controllers, Eloquent ORM, service layers, queues, events, caching, and API resources for production apps. Use when you need help with laravel patterns.databasesphpapiVotes: 0GitHub stars: 8
Ecc Kotlin Exposed PatternsAJetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and repository pattern. Use when you need help with kotlin exposed patterns.databasesgokotlinVotes: 0GitHub stars: 8
Ecc Jpa PatternsAJPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot. Use when you need help with jpa patterns.databasesjavasqlVotes: 0GitHub stars: 8
Ecc Database MigrationsADatabase migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate). Use when you need help with database migrations.databasestypescriptpythonVotes: 0GitHub stars: 8