Database

The WOFF and WOFF2 web font formats — compressed font containers optimized for efficient web delivery, enabling custom typography on websites with smaller file sizes.

XCF is the native file format for GIMP (GNU Image Manipulation Program), preserving layers, channels, paths, and all editing data for non-destructive raster image editing in the open-source ecosystem.

The legacy binary spreadsheet format used by Microsoft Excel from 1997 through 2003, storing worksheets, formulas, and formatting in an OLE2 compound file structure.

The modern Microsoft Excel spreadsheet format based on Open XML, storing worksheets, formulas, charts, pivot tables, and formatting in a ZIP-compressed package of XML files.

Extensible Markup Language — a verbose but powerful structured data format widely used in enterprise systems, document formats, and legacy APIs.

The XZ compression format — high-ratio single-stream compression using LZMA2, the modern standard for software distribution as tar.xz on Linux.

YAML Ain

The ZIP archive format — structure, creation, extraction, encryption, and cross-platform compatibility for the most widely used compressed archive format.

The Zstandard (zstd) compression format — Facebook

Master the strategies and techniques for safeguarding database integrity and ensuring business continuity through robust backup and recovery plans. Activate this skill when designing disaster recovery protocols, responding to data loss incidents, planning major system migrations, or optimizing data resilience for critical applications.

Implement and manage various caching strategies to reduce database load, improve application response times, and enhance scalability. Activate this skill when encountering high database latency, excessive database queries, slow user interfaces, or when optimizing for read-heavy workloads and cost efficiency.

Configure and manage database connection pools to maximize throughput, minimize latency, and prevent resource exhaustion. Activate this skill when applications experience connection timeouts, database "too many connections" errors, high connection churn, or when tuning application-to-database resource utilization.

Design and structure data for databases to ensure integrity, optimize performance, and support business logic effectively. Activate this skill when initiating new database projects, refactoring existing schemas, troubleshooting data consistency issues, or when planning for future application scalability and data evolution.

Harden database systems against unauthorized access, data breaches, and service disruption by implementing robust security controls. Activate this skill when designing new data infrastructure, auditing existing systems, responding to security incidents, or establishing a comprehensive data governance framework.

Implement and optimize full-text search capabilities in databases to provide fast, relevant, and natural language-aware retrieval of information. Activate this skill when simple `LIKE` queries are insufficient for search accuracy, performance, or when dealing with large volumes of text data requiring nuanced relevance ranking and language processing.

Design, implement, and query graph databases to effectively model and analyze highly connected data. Activate this skill when your data's relationships are as important as the data itself, requiring complex traversals, pathfinding, or network analysis that is cumbersome in relational systems.

Optimize database query performance by understanding, designing, and implementing effective indexing strategies. Activate this skill when encountering slow queries, designing new database tables, or performing database refactoring for performance enhancements.

Manage database schema and data changes in a controlled, versioned, and reversible manner. Activate this skill when evolving database schemas, deploying new features, refactoring existing data structures, or ensuring consistency across development, staging, and production environments.

Strategize and apply effective data modeling and access patterns for non-relational databases. Activate this skill when designing scalable, high-performance applications with flexible data requirements, or when optimizing existing NoSQL data stores for specific use cases like analytics, caching, or real-time processing.

Apply common Object-Relational Mapping (ORM) patterns to efficiently interact with databases, maintain data integrity, and boost developer productivity. Activate this skill when designing data access layers, optimizing database interactions, debugging ORM-related performance issues, or seeking to balance abstraction with control.

Identify, diagnose, and optimize slow database queries to improve application responsiveness and reduce database load. Activate this skill when encountering high database CPU utilization, slow application features, specific query timeouts, or general database sluggishness.

Architect and manage database replication topologies to achieve high availability, disaster recovery, and read scalability. Activate this skill when designing fault-tolerant database systems, scaling read-heavy workloads, setting up cross-region deployments, or troubleshooting replication lag and consistency issues.

Implement and manage database replication strategies to ensure high availability, disaster recovery, and read scalability for your data systems. Activate this skill when designing resilient architectures, planning for data redundancy, scaling read-heavy applications, or migrating data across environments.

Architect and refine database schemas to ensure data integrity, optimize query performance, and support application scalability. Activate this skill when initiating new database development, refactoring existing data models, or addressing persistent performance issues rooted in data structure.

Design and implement horizontal database sharding to distribute data across multiple nodes for improved scalability, throughput, and fault isolation. Activate this skill when a single database instance can no longer handle the workload, when planning for massive data growth, or when architecting globally distributed data systems.

Distribute a single logical database across multiple physical database instances to achieve horizontal scalability, improve performance, and enhance fault tolerance. Activate this skill when a monolithic database reaches its vertical scaling limits, experiences severe I/O bottlenecks, or requires increased read/write throughput beyond what a single server can provide.

Identify, analyze, and rewrite inefficient SQL queries to improve database performance, reduce resource consumption, and enhance application responsiveness. Activate this skill when encountering slow database operations, high CPU/IO usage from the database, or when optimizing application features that rely heavily on data retrieval.

Design, implement, and manage databases optimized for time-series data, characterized by high-volume, time-stamped events. Activate this skill when dealing with IoT sensor data, financial tick data, application metrics, monitoring logs, or any dataset where time is the primary dimension for analysis and retrieval.

Send email at scale with Amazon SES (Simple Email Service). Use this skill when the project needs to integrate AWS SES for transactional email, bulk sending, email receiving, configuration sets, event publishing, dedicated IPs, custom MAIL FROM domains, or cost-optimized high-volume email. Covers the SES v2 API, templates, configuration sets, event destinations, and deliverability dashboard.

Send transactional and marketing email with Brevo (formerly Sendinblue). Use this skill when the project needs to integrate Brevo for transactional email, marketing campaigns, SMS, WhatsApp, CRM contacts, automation workflows, or multi-channel messaging. Covers the Brevo API v3, transactional templates, contacts, campaigns, automation, and webhook processing.

Send transactional notifications including email with Courier. Use this skill when the project needs to integrate Courier for multi-channel notification orchestration, email delivery through multiple providers, template management with a visual designer, routing rules, user preference management, bulk sends, and delivery tracking. Covers the Send API, automations, user preferences, and provider failover.

Send transactional and marketing email with Customer.io. Use this skill when the project needs to integrate Customer.io for behavioral email automation, transactional messages via the Transactional API, event-driven campaigns, segment-based messaging, webhook handling, and customer data management. Covers the Track API, Transactional API, campaign workflows, and data-driven personalization.

Optimize email deliverability across any provider. Use this skill when the project needs to improve inbox placement, configure SPF, DKIM, and DMARC, manage sender reputation, handle bounces and complaints, warm new IPs or domains, or debug delivery issues. Provider-agnostic best practices for getting email into the inbox.

Send transactional and marketing email with Loops. Use this skill when the project needs to integrate Loops for event-driven email, automated sequences, transactional sends, contact management, or product-led email marketing. Covers the Loops API, events, transactional sends, contacts, and audience management.

Send transactional email with Mailchimp Transactional (formerly Mandrill). Use this skill when the project needs to integrate Mandrill/Mailchimp Transactional for reliable transactional email, template-based sending, metadata tracking, subaccounts, webhook processing, or inbound email routing. Covers the Mandrill API, templates, subaccounts, metadata, and webhooks.

Send transactional and marketing email with Mailgun. Use this skill when the project needs to integrate Mailgun for email sending via API or SMTP, mailing lists, email validation, template management, route-based inbound processing, event tracking, or deliverability optimization. Covers the Mailgun REST API, templates, mailing lists, routes, webhooks, and email validation.

Send transactional and marketing email with Mailjet. Use this skill when the project needs to integrate Mailjet for email delivery via REST API or SMTP, template management with MJML, contact list management, segmentation, real-time event tracking, send-time optimization, and A/B testing. Covers the Send API v3.1, template language, contact management, and event webhooks.

Send and test email with Mailtrap. Use this skill when the project needs to integrate Mailtrap for email testing in development, transactional email sending in production, email previewing, HTML validation, spam score checking, or sandbox email capture. Covers both Mailtrap Email Testing (sandbox) and Mailtrap Email Sending (production transactional API).

Send email with Nodemailer in Node.js. Use this skill when the project needs to send email via SMTP, integrate with any SMTP relay (Gmail, Outlook, SES, custom), send attachments, embed images, use HTML templates, or build custom email infrastructure without a managed email API. Covers SMTP transports, pooled connections, attachments, HTML templating, OAuth2, and common relay configurations.

Send transactional and marketing email with Plunk. Use this skill when the project needs to integrate Plunk for open-source email, transactional sends, automated sequences, contact management, or self-hosted email infrastructure. Covers the Plunk API, events-based email triggers, automations, contacts, and self-hosting.

Send transactional email with Postmark. Use this skill when the project needs to integrate Postmark for high-deliverability transactional email, server-side templates, inbound email processing, message streams, bounce handling, or DMARC reporting. Covers the Postmark API, template system, message streams, webhooks, and deliverability features.

Build email templates with React Email. Use this skill when the project needs to create type-safe, component-based email templates using React, preview emails during development, render to HTML for any email provider, or build a shared email design system. Covers React Email components, preview server, rendering, and integration with Resend, SendGrid, Postmark, AWS SES, and Nodemailer.

Send transactional and marketing email with Resend. Use this skill when the project needs to integrate Resend for sending email, managing contacts, handling webhooks, building templates, or setting up mailing lists and broadcasts. Covers single sends, batch sends, scheduling, React Email templates, domain verification, webhook processing, idempotency, deliverability, and compliance.

Send transactional and marketing email with SendGrid (Twilio). Use this skill when the project needs to integrate SendGrid for sending email via API or SMTP, dynamic templates, contact management, marketing campaigns, email validation, webhook event processing, or deliverability optimization. Covers the v3 Mail Send API, dynamic transactional templates, Marketing Campaigns, suppressions, and Event Webhook.

Send transactional and marketing email with SparkPost (now MessageBird). Use this skill when the project needs to integrate SparkPost for high-volume email delivery via REST API or SMTP, recipient lists, stored templates, A/B testing, engagement tracking, suppression management, webhooks, and deliverability analytics.

Build with Apache Cassandra for high-availability distributed data. Use this skill when the project needs a wide-column database for massive write throughput, multi-region replication, or always-on availability. Covers data modeling, partition keys, CQL, the cassandra-driver for Node.js, and operational patterns for production clusters.

Build with ClickHouse for real-time analytics and OLAP workloads. Use this skill when the project needs columnar storage for fast aggregation queries over billions of rows — log analytics, event tracking, product analytics, or business intelligence. Covers table engines, MergeTree family, materialized views, and the ClickHouse Node.js client.

Build with CockroachDB as a distributed SQL database. Use this skill when the project needs to integrate CockroachDB for globally distributed PostgreSQL-compatible SQL, multi-region deployments, serializable transactions, or horizontal scaling. Covers CockroachDB Serverless, node-postgres integration, multi-region patterns, and ORM compatibility.

Build with Convex as a reactive backend. Use this skill when the project needs to integrate Convex for real-time database, server functions, file storage, scheduled jobs, authentication, or full-stack TypeScript development with automatic reactivity. Covers the Convex client, queries, mutations, actions, schema validation, indexes, real-time subscriptions, and deployment.

Use Drizzle ORM for type-safe SQL in TypeScript. Use this skill when the project needs to integrate Drizzle for SQL-first database access, schema definition in TypeScript, migrations, relational queries, or connecting to PostgreSQL, MySQL, SQLite, Turso, Neon, PlanetScale, or Vercel Postgres. Covers Drizzle schema, query builder, relational API, migrations, and driver integrations.

Build with Amazon DynamoDB as a serverless NoSQL database. Use this skill when the project needs to integrate DynamoDB for key-value and document storage, single-table design, global tables, streams, TTL, or serverless-first data access. Covers the AWS SDK v3, single-table design, GSIs, queries, scans, transactions, and DynamoDB Streams.

Build with Fauna as a distributed document-relational database. Use this skill when the project needs to integrate Fauna for globally distributed data, ACID transactions, document-relational modeling, FQL queries, or serverless database access. Covers the Fauna v10 client, FQL, schema, indexes, and authentication.

Build with Firebase Firestore as a NoSQL document database. Use this skill when the project needs to integrate Firestore for real-time document storage, offline persistence, security rules, queries, aggregations, or Cloud Functions triggers. Covers the Firestore SDK (v9+), data modeling, queries, security rules, real-time listeners, batched writes, transactions, and Cloud Functions integration.

Build with MongoDB as a document database. Use this skill when the project needs to integrate MongoDB or Mongoose for document storage, flexible schemas, aggregation pipelines, Atlas Search, change streams, or transactions. Covers the MongoDB Node.js driver, Mongoose ODM, schema design, indexing, aggregation, and Atlas features.

Build with Neo4j for graph data and relationship-heavy queries. Use this skill when the project needs a graph database for social networks, recommendation engines, knowledge graphs, fraud detection, or any domain where relationships between entities are central. Covers Cypher query language, the Neo4j JavaScript driver, graph modeling, and common graph patterns.

Build with Neon as a serverless PostgreSQL database. Use this skill when the project needs to integrate Neon for serverless Postgres, branching, autoscaling, connection pooling, or edge-compatible database access. Covers the Neon serverless driver, branching workflows, connection pooling, and integration with ORMs.

Build with PlanetScale as a serverless MySQL database. Use this skill when the project needs to integrate PlanetScale for serverless MySQL, branching, non-blocking schema changes, connection pooling, or Vitess-powered horizontal scaling. Covers the PlanetScale serverless driver, branching, deploy requests, and ORM integration.

Use Prisma as a TypeScript ORM. Use this skill when the project needs to integrate Prisma for type-safe database access, schema modeling, migrations, relations, transactions, raw queries, or connecting to PostgreSQL, MySQL, SQLite, MongoDB, or CockroachDB. Covers the Prisma schema, client API, migrations, seeding, relations, and deployment patterns.

Build with Redis for caching, sessions, and real-time data. Use this skill when the project needs to integrate Redis or Upstash for in-memory caching, session storage, rate limiting, pub/sub, queues, leaderboards, or real-time counters. Covers the ioredis and @upstash/redis clients, data structures, caching patterns, and common use cases.

Build with Supabase as a backend-as-a-service. Use this skill when the project needs to integrate Supabase for PostgreSQL database, authentication, real-time subscriptions, storage, edge functions, row-level security, vector embeddings, or as a Firebase alternative. Covers the Supabase client SDK, database queries, auth, RLS policies, real-time, storage, and edge functions.