database▌

Design scalable, normalized database schemas with proper relationships, constraints, and data types. Includes normalization techniques, relationship patterns, and constraint strategies.

Encore provides several query methods:

database-design

Design and optimize SQL and NoSQL database schemas with normalization, indexing, and migration strategies. \n \n Covers entity definition, relationship design (1:1, 1:N, N:M), and normalization levels (1NF–3NF) for PostgreSQL, MySQL, MongoDB, and SQLite \n Provides indexing strategies, constraint setup, and trigger implementation to ensure data integrity and query performance \n Includes migration script generation with UP/DOWN rollback capabilities for safe schema evolution \n Delivers complete

Implement horizontal data partitioning across multiple database servers. Covers sharding strategies, consistent hashing, shard key selection, and cross-shard querying patterns.

This skill provides efficient Python-based tools for searching and retrieving preprints from the bioRxiv database. It enables comprehensive searches by keywords, authors, date ranges, and categories, returning structured JSON metadata that includes titles, abstracts, DOIs, and citation information. The skill also supports PDF downloads for full-text analysis.

Comprehensive database schema design patterns for PostgreSQL and MySQL with normalization, relationships, constraints, and error prevention.

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

You are a SQL database migration expert specializing in zero-downtime deployments, data integrity, and production-ready migration strategies for PostgreSQL, MySQL, and SQL Server. Create comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.

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.