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 3,649–3,672 of 4,314 skills

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: 8
Openalex DatabaseAQuery and analyze scholarly literature using the OpenAlex database. This skill should be used when searching for academic papers, analyzing research trends, finding works by authors or institutions, tracking citations, discovering open access publications, or conducting bibliometric analysis across 240M+ scholarly works. Use for literature searches, research output analysis, citation analysis, and academic database queries.databasespythongoVotes: 0GitHub stars: 8
Datacommons ClientAWork with Data Commons, a platform providing programmatic access to public statistical data from global sources. Use this skill when working with demographic data, economic indicators, health statistics, environmental data, or any public datasets available through Data Commons. Applicable for querying population statistics, GDP figures, unemployment rates, disease prevalence, geographic entity resolution, and exploring relationships between statistical entities.databasespythongoVotes: 0GitHub stars: 8
Clinvar DatabaseAQuery NCBI ClinVar for variant clinical significance. Search by gene/position, interpret pathogenicity classifications, access via E-utilities API or FTP, annotate VCFs, for genomic medicine.databasespythongoVotes: 0GitHub stars: 8
Pubchem DatabaseAQuery PubChem via PUG-REST API/PubChemPy (110M+ compounds). Search by name/CID/SMILES, retrieve properties, similarity/substructure searches, bioactivity, for cheminformatics.databasespythongoVotes: 0GitHub stars: 8
Brenda DatabaseAAccess BRENDA enzyme database via SOAP API. Retrieve kinetic parameters (Km, kcat), reaction equations, organism data, and substrate-specific enzyme information for biochemical research and metabolic pathway analysis.databasespythongoVotes: 0GitHub stars: 8
Geo DatabaseDAccess NCBI GEO for gene expression/genomics data. Search/download microarray and RNA-seq datasets (GSE, GSM, GPL), retrieve SOFT/Matrix files, for transcriptomics and expression analysis.databasespythongoVotes: 0GitHub stars: 8
Cellxgene CensusAQuery the CELLxGENE Census (61M+ cells) programmatically. Use when you need expression data across tissues, diseases, or cell types from the largest curated single-cell atlas. Best for population-scale queries, reference atlas comparisons. For analyzing your own data use scanpy or scvi-tools.databasespythongoVotes: 0GitHub stars: 8
Biorxiv DatabaseAEfficient database search tool for bioRxiv preprint server. Use this skill when searching for life sciences preprints by keywords, authors, date ranges, or categories, retrieving paper metadata, downloading PDFs, or conducting literature reviews.databasespythongoVotes: 0GitHub stars: 8
AnndataAData structure for annotated matrices in single-cell analysis. Use when working with .h5ad files or integrating with the scverse ecosystem. This is the data format skill—for analysis workflows use scanpy; for probabilistic models use scvi-tools; for population-scale queries use cellxgene-census.databasespythongoVotes: 0GitHub stars: 8
TicksAQuery historical tick, OHLC, and orderbook data from TimescaleDB.databasesdatabaseVotes: 0GitHub stars: 2,496
Search ConfigASearch indexing configuration and full-text search managementdatabasestypescriptsqlVotes: 0GitHub stars: 2,496
Mexc FuturesAMEXC Futures trading with DB tracking (No KYC)databasesbashapiVotes: 0GitHub stars: 2,496
HistoryATrade history tracking, sync, and performance analyticsdatabasestypescriptgoVotes: 0GitHub stars: 2,496
Supabase PostgresAPostgres performance optimization and best practices from Supabase — covering indexing, connection management, RLS security, schema design, locking, data access patterns, and monitoring. Use when writing SQL, designing schemas, optimizing queries, or configuring Postgres.databasesgobashVotes: 0GitHub stars: 11
Postgres Job QueueAPostgreSQL-based job queue with priority scheduling, batch claiming, and progress tracking. Use when building job queues without external dependencies. Triggers on PostgreSQL job queue, background jobs, task queue, priority queue, SKIP LOCKED.databasesgobashVotes: 0GitHub stars: 11
Event StoreADesign and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, implementing event persistence, projections, snapshotting, or CQRS patterns.databasespythongoVotes: 0GitHub stars: 11
Database MigrationsASafe, zero-downtime database migration strategies — schema evolution, rollback planning, data migration, tooling, and anti-pattern avoidance for production systems. Use when planning schema changes, writing migrations, or reviewing migration safety.databasesjavascripttypescriptVotes: 0GitHub stars: 11
Core Data PatternsAExpert Core Data decisions for iOS/tvOS: when Core Data vs alternatives, context architecture for multi-threading, migration strategy selection, and performance optimization trade-offs. Use when choosing persistence layer, debugging save failures, or optimizing fetch performance. Trigger keywords: Core Data, NSManagedObject, NSPersistentContainer, NSFetchRequest, FetchRequest, migration, lightweight migration, background context, merge policy, faultingdatabasesswiftsqlVotes: 0GitHub stars: 10
Rails Error PreventionAComprehensive checklist and prevention strategies for common Ruby on Rails errors. Use this skill BEFORE writing any Rails code to prevent ViewComponent template errors, ActiveRecord query mistakes, method exposure issues, N+1 queries, and other common Rails pitfalls.databasesgorubyVotes: 0GitHub stars: 10
Activerecord PatternsAComplete guide to ActiveRecord query optimization, associations, scopes, and PostgreSQL-specific patterns. Use this skill when writing database queries, designing model associations, creating migrations, optimizing query performance, or debugging N+1 queries and grouping errors.databasesgorubyVotes: 0GitHub stars: 10
Vector DatabaseAWork with vector databases for RAG, embeddings, and semantic search using ChromaDB or similar. Use when building knowledge bases for PSI Engine or AI-powered search.databasesjavascriptpythonVotes: 0GitHub stars: 33
Legacy ModernizationAModernize legacy applications and codebases. Use for COBOL conversion, framework upgrades, and technical debt reduction.databasesjavascriptgoVotes: 0GitHub stars: 33
Database ManagementADatabase schema design, migrations, query optimization, and ORM best practices. Use for database setup, performance tuning, and data modeling.databasesjavascriptgoVotes: 0GitHub stars: 33