Database

The standard uncompressed audio format for Windows, storing raw PCM audio data with full fidelity for professional editing and archival.

WebM is an open, royalty-free multimedia container format developed by Google for the web, using VP8, VP9, or AV1 video with Vorbis or Opus audio.

WebP is a modern image format developed by Google that provides both lossy and

Microsoft's proprietary audio codec family for the Windows platform, including lossy, lossless, and professional variants.

WMV is Microsoft's proprietary video codec and format, used within the ASF container, once common for Windows-based media distribution and streaming.

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),

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't Markup Language — a human-friendly data serialization format popular for configuration files, CI/CD pipelines, and infrastructure-as-code.

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's modern compressor offering dramatically better speed-to-ratio tradeoffs than gzip, with dictionary support and streaming capabilities.

Master the strategies and techniques for safeguarding database integrity and ensuring business continuity through robust backup and recovery plans.

Implement and manage various caching strategies to reduce database load, improve application response times, and

Configure and manage database connection pools to maximize throughput, minimize latency, and

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,

Design, implement, and query graph databases to effectively model and analyze highly connected data.

Optimize database query performance by understanding, designing, and implementing effective indexing strategies.

Manage database schema and data changes in a controlled, versioned, and reversible manner.

Strategize and apply effective data modeling and access patterns for non-relational databases.

Apply common Object-Relational Mapping (ORM) patterns to efficiently interact with databases,

Identify, diagnose, and optimize slow database queries to improve application responsiveness and

Architect and manage database replication topologies to achieve high availability, disaster

Implement and manage database replication strategies to ensure high availability, disaster recovery,

Architect and refine database schemas to ensure data integrity, optimize query performance,

Design and implement horizontal database sharding to distribute data across multiple nodes

Distribute a single logical database across multiple physical database instances to achieve horizontal

Identify, analyze, and rewrite inefficient SQL queries to improve database performance,

Design, implement, and manage databases optimized for time-series data, characterized by high-volume,

Send email at scale with Amazon SES (Simple Email Service). Use this skill when

Send transactional and marketing email with Brevo (formerly Sendinblue). Use this

Send transactional notifications including email with Courier. Use this skill when

Send transactional and marketing email with Customer.io. Use this skill when the

Optimize email deliverability across any provider. Use this skill when the project

Send transactional and marketing email with Loops. Use this skill when the project

Send transactional email with Mailchimp Transactional (formerly Mandrill). Use

Send transactional and marketing email with Mailgun. Use this skill when the

Send transactional and marketing email with Mailjet. Use this skill when the project

Send and test email with Mailtrap. Use this skill when the project needs to

Send email with Nodemailer in Node.js. Use this skill when the project needs to

Send transactional and marketing email with Plunk. Use this skill when the project

Send transactional email with Postmark. Use this skill when the project needs

Build email templates with React Email. Use this skill when the project needs to

Send transactional and marketing email with Resend. Use this skill when the

Send transactional and marketing email with SendGrid (Twilio). Use this skill

Send transactional and marketing email with SparkPost (now MessageBird). Use this

Build with Apache Cassandra for high-availability distributed data. Use this skill

Build with ClickHouse for real-time analytics and OLAP workloads. Use this skill

Build with CockroachDB as a distributed SQL database. Use this skill when the

Build with Convex as a reactive backend. Use this skill when the project needs

Use Drizzle ORM for type-safe SQL in TypeScript. Use this skill when the project

Build with Amazon DynamoDB as a serverless NoSQL database. Use this skill when

Build with Fauna as a distributed document-relational database. Use this skill

Build with Firebase Firestore as a NoSQL document database. Use this skill when

Build with MongoDB as a document database. Use this skill when the project needs

Build with Neo4j for graph data and relationship-heavy queries. Use this skill when