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 505–528 of 4,314 skills

Crsp V2AUse when "CRSP CIZ", "CRSP v2", "CRSP flat file format 2.0", "crsp.dsf_v2 / msf_v2", "StkDlySecurityData", "StkMthSecurityData", "StkSecurityInfoHist", "stocknames_v2", "DlyRet / MthRet / DlyPrc / MthPrc", "SHRCD or EXCHCD equivalent in new CRSP", "SIZ to CIZ migration", "CRSP data after 2024", "CRSP delisting returns", "CRSP cumulative adjustment factors", "CRSP index INDNO / INDFAM", or any CRSP stock/index query where the legacy SIZ column names no longer exist.databasespythongoVotes: 0GitHub stars: 22
Crsp Lseg SpliceAUse when "CRSP is stale / out of date", "CRSP only goes through December", "my panel ends in December", "why do my returns stop", "extend CRSP to today", "fill forward CRSP with LSEG", "current stock prices for my CRSP panel", "up-to-date returns for permnos", "splice CRSP and LSEG", "CUSIP to RIC for a CRSP universe", "backfill the CRSP gap", or any request to carry a CRSP daily/monthly stock series past CRSP''s last data date using LSEG/Refinitiv. Use proactively whenever a CRSP panel has t...databasespythonrustVotes: 0GitHub stars: 22
CourtlistenerAUse when the user says 'CourtListener', 'Free Law Project', 'RECAP', 'PACER data', 'court opinions', 'get the opinion text', 'federal dockets', 'delch', 'Delaware Chancery opinions', 'state court opinions', 'demand futility opinions', 'judicial financial disclosures', 'oral arguments', or needs case law, dockets or opinion full text for empirical legal research. Also use when someone assumes CourtListener is federal-only, or hits a token or human-verification wall on it.databasessqlawsVotes: 0GitHub stars: 22
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.databasesgosqlVotes: 0GitHub stars: 2
Snowflake SemanticviewACreate, alter, and validate Snowflake semantic views using Snowflake CLI (snow). Use when asked to build or troubleshoot semantic views/semantic layer definitions with CREATE/ALTER SEMANTIC VIEW, to validate semantic-view DDL against Snowflake via CLI, or to guide Snowflake CLI installation and connection setup.databasesgobashVotes: 0GitHub stars: 2
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: 2
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.databasesgosqlVotes: 0GitHub stars: 2
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).databasesgosqlVotes: 0GitHub stars: 2
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.databasesgosqlVotes: 0GitHub stars: 2
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.databasesgosqlVotes: 0GitHub stars: 2
Creating Oracle To Postgres Master Migration PlanADiscovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. Use when starting a multi-project Oracle-to-PostgreSQL migration, creating a migration inventory, or assessing which .NET projects contain Oracle dependencies.databasesgosqlVotes: 0GitHub stars: 2
Create Spring Boot Kotlin ProjectACreate Spring Boot Kotlin Project SkeletondatabasesgojavaVotes: 0GitHub stars: 2
Create Spring Boot Java ProjectACreate Spring Boot Java Project SkeletondatabasesgojavaVotes: 0GitHub stars: 2
V3 Memory UnificationAUnify 6+ memory systems into AgentDB with HNSW indexing for 150x-12,500x search improvements. Implements ADR-006 (Unified Memory Service) and ADR-009 (Hybrid Memory Backend).databasestypescriptbashVotes: 0GitHub stars: 2
V3 Memory UnificationAUnify 6+ memory systems into AgentDB with HNSW indexing for 150x-12,500x search improvements. Implements ADR-006 (Unified Memory Service) and ADR-009 (Hybrid Memory Backend).databasestypescriptgoVotes: 0GitHub stars: 2
Obsidian BasesACreate and edit Obsidian Bases (.base files) with views, filters, formulas, and summaries. Use when working with .base files, creating database-like views of notes, or when the user mentions Bases, table views, card views, filters, or formulas in Obsidian.databasesgoexpressVotes: 0GitHub stars: 2
TeamAN coordinated agents on shared task list using Claude Code native teamsdatabasestypescriptgoVotes: 0GitHub stars: 2
External ContextAInvoke parallel document-specialist agents for external web searches and documentation lookupdatabasesgosqlVotes: 0GitHub stars: 2
Postgres PatternsAPostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.databasesgosqlVotes: 0GitHub stars: 2
Laravel TddATest-driven development for Laravel with PHPUnit and Pest, factories, database testing, fakes, and coverage targets.databasesgophpVotes: 0GitHub stars: 2
Laravel PatternsALaravel architecture patterns, routing/controllers, Eloquent ORM, service layers, queues, events, caching, and API resources for production apps.databasesgophpVotes: 0GitHub stars: 2
Kotlin Exposed PatternsAJetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and repository pattern.databasesgokotlinVotes: 0GitHub stars: 2
Jpa PatternsAJPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.databasesgojavaVotes: 0GitHub stars: 2
Django PatternsADjango architecture patterns, REST API design with DRF, ORM best practices, caching, signals, middleware, and production-grade Django apps.databasespythongoVotes: 0GitHub stars: 2