database▌

Step-by-step configuration guides for Prisma ORM across PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, CockroachDB, and Prisma Postgres. \n \n Covers datasource configuration, driver adapter selection, and Prisma Client instantiation for seven database providers \n Prisma v7 requires explicit driver adapters (e.g., @prisma/adapter-pg for PostgreSQL) and a prisma.config.ts file for connection URLs \n Includes quick-reference schema blocks and prerequisite checks (Node.js 20.19.0+, TypeScript 5.4

DrugBank is a comprehensive bioinformatics and cheminformatics database containing detailed information on drugs and drug targets. This skill enables programmatic access to DrugBank data including ~9,591 drug entries (2,037 FDA-approved small molecules, 241 biotech drugs, 96 nutraceuticals, and 6,000+ experimental compounds) with 200+ data fields per entry.

Execute database migrations across ORMs with zero-downtime strategies and rollback procedures. \n \n Supports three major ORMs: Sequelize, TypeORM, and Prisma, with migration syntax and CLI commands for each \n Covers schema transformations including column additions, renames, type changes, and data restructuring with multi-step approaches for large tables \n Includes transaction-based and checkpoint-based rollback strategies to safely recover from failed migrations \n Provides zero-downtime dep