database▌

Production-ready SQL and NoSQL schemas with normalization, indexing, and migration strategies built in. \n \n Generates complete schemas from natural language descriptions, covering entities, relationships, constraints, and indexes tailored to SQL or NoSQL databases \n Provides normalization guidance (1NF through 3NF), foreign key strategies with ON DELETE rules, and composite index planning based on access patterns \n Includes anti-patterns reference (FLOAT for money, missing FK indexes, non-re

Safe, reversible database schema changes for production systems. \n \n Covers PostgreSQL, MySQL, and five major ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate) with workflow examples and schema patterns for each \n Enforces core principles: immutable deployed migrations, forward-only production rollbacks, and separation of schema (DDL) from data (DML) migrations \n Provides the expand-contract pattern for zero-downtime column renames and large refactors, with concrete timeline examples \

This skill provides tools for working with Supabase database tables through the REST API. Supports SELECT queries with filtering, INSERT, UPDATE, DELETE operations, and calling RPC functions.

Frontend CloudBase Relational Database client initialization with Supabase-compatible query API. \n \n Provides canonical synchronous initialization pattern using @cloudbase/js-sdk for browser-based apps (React, Vue, vanilla JS) \n Returns a shared db client that uses identical method names and patterns to Supabase for queries, inserts, updates, and deletes \n Enforces single-client reuse across components; prohibits lazy-loading, async wrappers, and re-initialization \n Handles only frontend da

ZINC is a freely accessible repository of 230M+ purchasable compounds maintained by UCSF. Search by ZINC ID or SMILES, perform similarity searches, download 3D-ready structures for docking, discover analogs for virtual screening and drug discovery.

Amazon RDS simplifies relational database deployment and operations. Support multiple database engines with automated backups, replication, encryption, and high availability through Multi-AZ deployments.

The Human Metabolome Database (HMDB) is a comprehensive, freely available resource containing detailed information about small molecule metabolites found in the human body.

UniProt is the world's leading comprehensive protein sequence and functional information resource. Search proteins by name, gene, or accession, retrieve sequences in FASTA format, perform ID mapping across databases, access Swiss-Prot/TrEMBL annotations via REST API for protein analysis.

NCBI Gene is a comprehensive database integrating gene information from diverse species. It provides nomenclature, reference sequences (RefSeqs), chromosomal maps, biological pathways, genetic variations, phenotypes, and cross-references to global genomic resources.

PubChem is the world's largest freely available chemical database with 110M+ compounds and 270M+ bioactivities. Query chemical structures by name, CID, or SMILES, retrieve molecular properties, perform similarity and substructure searches, access bioactivity data using PUG-REST API and PubChemPy.