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,273–4,296 of 4,314 skills

Scientific Pkg BioservicesAPrimary Python tool for 40+ bioinformatics services. Preferred for multi-database workflows: UniProt, KEGG, ChEMBL, PubChem, Reactome, QuickGO. Unified API for queries, ID mapping, pathway analysis. For direct REST control, use individual database skills (uniprot-database, kegg-database).databasespythongoVotes: 0GitHub stars: 16
Scientific Integration Omero IntegrationAMicroscopy data management platform. Access images via Python, retrieve datasets, analyze pixels, manage ROIs/annotations, batch processing, for high-content screening and microscopy workflows.databasespythongoVotes: 0GitHub stars: 16
Scientific Integration Labarchive IntegrationAElectronic lab notebook API integration. Access notebooks, manage entries/attachments, backup notebooks, integrate with Protocols.io/Jupyter/REDCap, for programmatic ELN workflows.databasespythonphpVotes: 0GitHub stars: 16
Scientific Db 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: 16
Scientific Db 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: 16
Scientific Db 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: 16
Scientific Db Ensembl DatabaseAQuery Ensembl genome database REST API for 250+ species. Gene lookups, sequence retrieval, variant analysis, comparative genomics, orthologs, VEP predictions, for genomic research.databasespythongoVotes: 0GitHub stars: 16
Scientific Db Drugbank DatabaseAAccess and analyze comprehensive drug information from the DrugBank database including drug properties, interactions, targets, pathways, chemical structures, and pharmacology data. This skill should be used when working with pharmaceutical data, drug discovery research, pharmacology studies, drug-drug interaction analysis, target identification, chemical similarity searches, ADMET predictions, or any task requiring detailed drug and drug target information from DrugBank.databasespythongoVotes: 0GitHub stars: 16
Scientific Db Chembl DatabaseAQuery ChEMBL's bioactive molecules and drug discovery data. Search compounds by structure/properties, retrieve bioactivity data (IC50, Ki), find inhibitors, perform SAR studies, for medicinal chemistry.databasespythongoVotes: 0GitHub stars: 16
Scientific Db Alphafold DatabaseAAccess AlphaFold's 200M+ AI-predicted protein structures. Retrieve structures by UniProt ID, download PDB/mmCIF files, analyze confidence metrics (pLDDT, PAE), for drug discovery and structural biology.databasespythongoVotes: 0GitHub stars: 16
Cloudflare VectorizeAComplete knowledge domain for Cloudflare Vectorize - globally distributed vector database for building semantic search, RAG (Retrieval Augmented Generation), and AI-powered applications. Use when: creating vector indexes, inserting embeddings, querying vectors, implementing semantic search, building RAG systems, configuring metadata filtering, working with Workers AI embeddings, integrating with OpenAI embeddings, or encountering metadata index timing errors, dimension mismatches, filter syn...databasestypescriptgoVotes: 0GitHub stars: 16
Cloudflare HyperdriveAComplete knowledge domain for Cloudflare Hyperdrive - connecting Cloudflare Workers to existing PostgreSQL and MySQL databases with global connection pooling, query caching, and reduced latency. Use when: connecting Workers to existing databases, migrating PostgreSQL/MySQL to Cloudflare, setting up connection pooling, configuring Hyperdrive bindings, using node-postgres/postgres.js/mysql2 drivers, integrating Drizzle ORM or Prisma ORM, or encountering "Failed to acquire a connection from the...databasestypescriptgoVotes: 0GitHub stars: 16
Sql ProAOptimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between data...databasessqlgitVotes: 0GitHub stars: 11,720
Postgres ProAUse when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.databasesgosqlVotes: 0GitHub stars: 11,720
Database OptimizerAOptimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.databasessqlgitVotes: 0GitHub stars: 11,720
Using Graph DatabasesAGraph database implementation for relationship-heavy data models. Use when building social networks, recommendation engines, knowledge graphs, or fraud detection. Covers Neo4j (primary), ArangoDB, Amazon Neptune, Cypher query patterns, and graph data modeling.databasestypescriptpythonVotes: 0GitHub stars: 517
Spring Data Neo4jAProvides Spring Data Neo4j integration patterns for Spring Boot applications. Use when you need to work with a graph database, Neo4j nodes and relationships, Cypher queries, or Spring Data Neo4j. Creates node entities with @Node annotation, defines relationships with @Relationship, writes Cypher queries using @Query, configures imperative and reactive Neo4j repositories, implements graph traversal patterns, and sets up testing with embedded databases.databasesgojavaVotes: 0GitHub stars: 345
Spring Data JpaAProvides patterns to implement persistence layers with Spring Data JPA. Use when creating repositories, configuring entity relationships, writing queries (derived and `@Query`), setting up pagination, database auditing, transactions, UUID primary keys, multiple databases, and database indexing.databasesgojavaVotes: 0GitHub stars: 345
Weaviate Data IngestionAThis skill helps you upload data to your **local Weaviate collections** efficiently, handling everything from single objects to large batch imports.databasespythongoVotes: 0GitHub stars: 39
Weaviate ConnectionBThis skill helps you connect to a **local Weaviate database** instance running in Docker and verify the connection is healthy.databasespythonbashVotes: 0GitHub stars: 39
Weaviate Collection ManagerAThis skill helps you manage Weaviate collections on your **local Weaviate instance** - creating new ones, viewing existing schemas, and managing collection configurations.databasespythongoVotes: 0GitHub stars: 39
Wheels Migration GeneratorAGenerate database-agnostic Wheels migrations for creating tables, altering schemas, and managing database changes. Use when creating or modifying database schema, adding tables, columns, indexes, or foreign keys. Prevents database-specific SQL and ensures cross-database compatibility.databasesbashsqlVotes: 0GitHub stars: 393
Validate With DatabaseAUse this skill to connect to the test PostgreSQL database, validate assumptions about schema behavior, and cross-validate between pg_dump and pgschema implementations.databasesgobashVotes: 0GitHub stars: 393
SqlAYou are tasked with running SQL queries against the WordPress development database.databasesphpbashVotes: 0GitHub stars: 393