database▌

SQLite database expert for Tauri/desktop apps with SQL injection prevention, migrations, FTS search, and secure data handling. \n \n Enforces parameterized queries and input validation to prevent SQL injection; includes security checklist and reference patterns for all user-input database operations \n Covers database initialization with performance PRAGMAs (WAL mode, foreign keys), transaction management, connection pooling, and batch operations \n Implements Full-Text Search (FTS5) with virtua

Structured guidance for database selection, schema design, and query optimization decisions. \n \n Covers six core areas: database selection (PostgreSQL, Neon, Turso, SQLite), ORM choice (Drizzle, Prisma, Kysely), schema normalization, indexing strategy, query optimization, and safe migrations \n Emphasizes context-driven decision-making rather than defaulting to PostgreSQL; includes a checklist for schema design prerequisites \n Highlights common anti-patterns: unnecessary PostgreSQL adoption,

CloudBase document database operations for WeChat MiniProgram with query, CRUD, and aggregation support. \n \n Provides CRUD operations, complex queries, pagination, aggregation, and geolocation queries through the CloudBase SDK \n Built-in WeChat authentication; no explicit login required, with automatic user context in cloud functions \n Requires type definitions and model layers per collection as a single source of truth for schema validation \n Database security rules must be configured via

Deploy PostgreSQL, Redis, MySQL, or MongoDB with pre-configured volumes, networking, and connection variables. \n \n Supports four official database templates: PostgreSQL, Redis, MySQL, and MongoDB, each with persistent volumes and automatic connection variable setup \n Always checks for existing databases before creating to avoid duplicates; queries environment config via GraphQL to detect running instances \n Provides reference variables for connecting other services (e.g., ${{Postgres.DATABAS

The European Nucleotide Archive (ENA) is a comprehensive public repository for nucleotide sequence data and associated metadata. Access and query DNA/RNA sequences, raw reads, genome assemblies, and functional annotations through REST APIs and FTP for genomics and bioinformatics pipelines.

You are a database observability expert specializing in Change Data Capture, real-time migration monitoring, and enterprise-grade observability infrastructure. Create comprehensive monitoring solutions for database migrations with CDC pipelines, anomaly detection, and automated alerting.

STRING is a comprehensive database of known and predicted protein-protein interactions covering 59M proteins and 20B+ interactions across 5000+ organisms. Query interaction networks, perform functional enrichment, discover partners via REST API for systems biology and pathway analysis.

RCSB PDB is the worldwide repository for 3D structural data of biological macromolecules. Search for structures, retrieve coordinates and metadata, perform sequence and structure similarity searches across 200,000+ experimentally determined structures and computed models.

Diagnose and resolve database performance issues across PostgreSQL and MySQL with query analysis and optimization strategies. \n \n Analyzes slow queries using EXPLAIN ANALYZE , identifies missing indexes, and designs covering index strategies \n Provides database-specific tuning guidance for PostgreSQL and MySQL configuration, schema design, and partitioning \n Includes reference materials for query optimization, index strategies, monitoring, and lock contention resolution \n Delivers before/af

You are a cloud cost optimization expert specializing in reducing infrastructure expenses while maintaining performance and reliability. Analyze cloud spending, identify savings opportunities, and implement cost-effective architectures across AWS, Azure, and GCP.