Databases

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

skills in category: 4,315
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 721–744 of 4,315 skills

Bio Databases PlatformsA> [!info] What it does > Submit compact IPD REST requests for HLA allele and cell-level metadata using the public IPD query API. Use when a user wants concise IPD summaries; save raw JSON or text only on request. **Source:** [skills/ipd-skill/SKILL.md](../../../skills/ipd-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) · **Index:** [Skills Index](../../index.md)databasesapidatabaseVotes: 0GitHub stars: 8
Bio Databases PlatformsA> [!info] What it does > Submit compact Human Protein Atlas requests for gene JSON, search downloads, and page-level tissue or cell-line lookups. Use when a user wants concise Human Protein Atlas summaries; save raw JSON or HTML only on request. **Source:** [skills/human-protein-atlas-skill/SKILL.md](../../../skills/human-protein-atlas-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) ...databasesdatabaseVotes: 0GitHub stars: 8
Bio Databases PlatformsA> [!info] What it does > Submit compact EVA REST requests for species metadata and archived variant lookups. Use when a user wants concise European Variation Archive summaries **Source:** [skills/eva-skill/SKILL.md](../../../skills/eva-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) · **Index:** [Skills Index](../../index.md)databasesdatabaseVotes: 0GitHub stars: 8
Bio Databases PlatformsA> [!info] What it does > Submit compact EpiGraphDB API requests for ontology, literature, MR, gene-drug, and support-path evidence. Use when a user wants concise EpiGraphDB summaries **Source:** [skills/epigraphdb-skill/SKILL.md](../../../skills/epigraphdb-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) · **Index:** [Skills Index](../../index.md)databasesapidatabaseVotes: 0GitHub stars: 8
Bio Databases PlatformsA> [!info] What it does > Submit compact Ensembl REST API requests for lookup, overlap, cross-reference, and variation endpoints. Use when a user wants concise Ensembl summaries **Source:** [skills/ensembl-skill/SKILL.md](../../../skills/ensembl-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) · **Index:** [Skills Index](../../index.md)databasesapidatabaseVotes: 0GitHub stars: 8
Bio Databases PlatformsA> [!info] What it does > Submit compact EFO OLS4 requests for search, term lookup, children, and descendants. Use when a user wants concise EFO resolution or ontology-expansion summaries **Source:** [skills/efo-ontology-skill/SKILL.md](../../../skills/efo-ontology-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) · **Index:** [Skills Index](../../index.md)databasesdatabaseVotes: 0GitHub stars: 8
Bio Databases PlatformsA> [!info] What it does > Submit compact CELLxGENE Discover API requests for public collection and dataset metadata. Use when a user wants concise single-cell collection summaries **Source:** [skills/cellxgene-skill/SKILL.md](../../../skills/cellxgene-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) · **Index:** [Skills Index](../../index.md)databasesapidatabaseVotes: 0GitHub stars: 8
Bio Databases PlatformsA> [!info] What it does > Submit compact cBioPortal API requests for studies, molecular profiles, mutations, clinical data, and samples. Use when a user wants concise cBioPortal summaries **Source:** [skills/cbioportal-skill/SKILL.md](../../../skills/cbioportal-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) · **Index:** [Skills Index](../../index.md)databasesapidatabaseVotes: 0GitHub stars: 8
Bio Databases PlatformsA> [!info] What it does > Submit compact BioStudies and ArrayExpress API requests for free-text search and accession-based study retrieval. Use when a user wants concise BioStudies summaries **Source:** [skills/biostudies-arrayexpress-skill/SKILL.md](../../../skills/biostudies-arrayexpress-skill/SKILL.md) · **Domain:** [Bio Databases, Lab & Cloud Platforms](../../maps/bio-databases-platforms.md) · **Table:** [skills.base](../../skills.base) · **Index:** [Skills Index](../../index.md)databasesexpressapiVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Use when building Spring Boot applications with Neo4j using Spring Data Neo4j (SDN 7.x/8.x) — @Node entity mapping, @Relationship, @RelationshipProperties, Neo4jRepository, ReactiveNeo4jRepository, @Query annotations, application.yml configuration, projections, Neo4jClient, Neo4jTemplate, transactions, auditing, or Spring AI Neo4jVectorStore vector search. Does NOT handle raw Java driver code without Spring — use neo4j-driver-java-skill. Does NOT handle Cypher query a...databasesjavareactVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Use when reading from or writing to Neo4j with Apache Spark or Databricks using the Neo4j Connector for Apache Spark 6.0 (org.neo4j.connectors:spark) or 5.x (org.neo4j:neo4j-connector-apache-spark). Covers SparkSession setup, DataFrame reads via labels/Cypher/relationship scan, DataFrame writes with SaveMode, node.keys for MERGE, relationship write mapping, partition and batch tuning, PySpark and Scala examples, Databricks cluster config, Databricks secrets for creden...databasespythongoVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Programmatic security management in Neo4j — RBAC/ABAC, user lifecycle (CREATE/ALTER/DROP USER), role lifecycle (CREATE/GRANT ROLE/DROP ROLE), privilege grants and denies (GRANT/DENY/REVOKE on graph, database, DBMS), property-level access control, sub-graph access control, SHOW PRIVILEGES inspection, and auth provider config reference (LDAP, OIDC/SSO). Use when an agent needs to manage users, roles, or privileges programmatically via Cypher on the system database. Does...databasesnextjsdockerVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Diagnoses and fixes slow Neo4j Cypher queries by reading execution plans, identifying bad operators (AllNodesScan, CartesianProduct, Eager, NodeByLabelScan), and prescribing fixes (indexes, hints, query rewrites, runtime selection). Use when a query is slow, when EXPLAIN or PROFILE output needs interpretation, when dbHits or pageCacheHitRatio are poor, when cardinality estimation diverges from actuals, or when deciding between slotted/pipelined/parallel runtimes. Cove...databasespythongoVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Design, review, and refactor Neo4j graph data models. Use when choosing node labels vs relationship types vs properties, migrating relational/document schemas to graph, detecting anti-patterns (generic labels, supernodes, missing constraints), designing intermediate nodes for n-ary relationships, enforcing schema with constraints and indexes, or assessing an existing model against graph modeling best practices. Does NOT handle Cypher query authoring — use neo4j-cypher...databasesnodespringVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Configure and operate the Neo4j Connector for Kafka (sink + source) and the native Neo4j CDC API. Covers Cypher/Pattern/CUD sink strategies, CDC-based and query-based source, exactly-once semantics, DLQ error handling, Confluent Cloud managed connector, schema registry (Avro/JSON), and native db.cdc.query cursor-loop patterns (Neo4j 5.13+ Enterprise/Aura BC/VDC). Use when streaming Kafka events into Neo4j, streaming Neo4j changes to Kafka, or querying Neo4j change eve...databasespythongoVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Import structured data into Neo4j — LOAD CSV, CALL IN TRANSACTIONS, neo4j-admin database import full (offline bulk), apoc.load.csv/json, apoc.periodic.iterate, driver batch writes. Covers method selection, header file format, type coercion, null handling, ON ERROR modes, CONCURRENT TRANSACTIONS, pre-import constraint setup, and post-import validation. Use when importing CSV/JSON/Parquet files, migrating relational data to graph, or bulk-loading large datasets. Does NO...databasesdockerapiVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Neo4j Python Driver v6 — driver lifecycle, execute_query, managed and explicit transactions, async (AsyncGraphDatabase), result handling, data type mapping, error handling, UNWIND batching, connection pool tuning, and causal consistency. Use when writing Python code that connects to Neo4j via GraphDatabase.driver, execute_query, execute_read, execute_write, AsyncGraphDatabase, neo4j.Result, or RoutingControl. Package name is `neo4j` (not neo4j-driver) since v6. Python...databasespythondatabaseVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Neo4j JavaScript/TypeScript Driver v6 — driver lifecycle, executeQuery, managed transactions (executeRead/executeWrite), session.run, Integer handling, JSON serialization, record access, async/await patterns, TypeScript types, error handling, and connection setup for Node.js and browser. Use when writing JS/TS code that connects to Neo4j — neo4j.driver(), executeQuery, executeRead, executeWrite, session.run, neo4j.int, record.get, Integer, BookmarkManager, bolt://, ne...databasesjavascripttypescriptVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Neo4j Java Driver v6 — driver lifecycle, Maven/Gradle setup, executableQuery, executeRead/Write managed transactions, explicit transactions, async/reactive patterns, error handling, data type mapping, connection pool tuning, causal consistency/bookmarks. Use when writing Java or Kotlin code that connects to Neo4j via GraphDatabase.driver, executableQuery, SessionConfig, executeRead, executeWrite, or TransactionCallback. Does NOT handle Cypher authoring — use neo4j-cyp...databasesjavakotlinVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Covers the Neo4j Go Driver v6 — driver lifecycle, ExecuteQuery, managed and explicit transactions, session config, error handling, data type mapping, and connection tuning. Use when writing Go code that connects to Neo4j, setting up NewDriver or ExecuteQuery, debugging sessions/transactions/result handling, or working with neo4j-go-driver v5→v6 migration. Triggers on NewDriver, ExecuteQuery, SessionConfig, ManagedTransaction, neo4j-go-driver. Does NOT handle Cypher qu...databasesgodebuggingVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Neo4j .NET Driver v6 — IDriver lifecycle, DI registration (singleton), ExecutableQuery fluent API, ExecuteReadAsync/ExecuteWriteAsync managed transactions, IResultCursor (FetchAsync/ ToListAsync), record value access (.Get<T>/As<T>), null safety, UNWIND batching, temporal types, await using, EagerResult, object mapping, CancellationToken, error handling, and common traps. Use when writing C# or .NET code connecting to Neo4j. Also triggers on Neo4j.Driver, IDriver, Exe...databasesc#apiVotes: 0GitHub stars: 8
Analytics EngineeringA> [!info] What it does > Ingests unstructured and semi-structured documents into Neo4j as a knowledge graph. Use when chunking PDFs, HTML, plain text, or Markdown; extracting entities and relationships from text with an LLM (SimpleKGPipeline, neo4j-graphrag); loading JSON via apoc.load.json; building Document→Chunk→Entity graph structures; or connecting LangChain/LlamaIndex document loaders to Neo4j. Covers neo4j-graphrag SimpleKGPipeline, LLM Graph Builder web UI, entity resolution, chunking...databasespythondatabaseVotes: 0GitHub stars: 8
Analytics EngineeringD> [!info] What it does > Use when working with Neo4j command-line tools — neo4j-cli (modern unified CLI — Cypher via Bolt, schema inspection, Aura management, Docker containers, credential management, agent skill catalog install; install with curl -sSfL https://neo4j.sh/install.sh | bash), neo4j-admin (backup, restore, import, memory sizing), cypher-shell (ad-hoc queries, scripting, CI/CD), or neo4j-mcp (quick MCP server install). Does NOT cover Cypher query authoring — use neo4j-cypher-skill...databasesshellbashVotes: 0GitHub stars: 8
Sqlite ExpertASQLite expert for WAL mode, query optimization, embedded patterns, and advanced features. Use when working with .sqlite/.db files, SQLite schema design or migrations, PRAGMA tuning, FTS5 full-text search, JSON1, EXPLAIN QUERY PLAN, SQLITE_BUSY or locking errors, or choosing between SQLite and a client-server database.databasesgosqlVotes: 0GitHub stars: 8