Skill UI

A comprehensive reference guide providing quantitative benchmarks and formulas for system architects. It covers user-to-RPS conversion, storage estimation, bandwidth calculation, known scale limits of major technologies (databases, queues, caches), and capacity planning for various user loads (1K DAU to 10M DAU). Essential for designing scalable, high-availability applications.

A comprehensive guide detailing the selection criteria for core modern system components, including databases (SQL/NoSQL), caching, message queues, and API protocols. It helps architects choose the optimal technology for specific use cases, scalability needs, and architectural patterns.

This skill generates a comprehensive, safe, and zero-downtime database migration plan for schema changes. It utilizes the industry-standard expand/contract pattern to ensure backward compatibility, detailing multiple phased steps (Expand, Backfill, Contract), necessary SQL scripts, robust rollback procedures, and detailed deployment runbooks. Essential for maintaining application availability during large-scale database updates.

This skill generates comprehensive, production-ready database schema documents. It covers Entity-Relationship (ER) diagrams, detailed SQL DDL definitions, constraint analysis, index strategies, and access pattern optimization. Use it when designing a new database, documenting an existing one, or modeling complex data relationships for engineering review.

Programmatically manage your entire contact database within Mailtrap. This guide covers using the API to create, update, delete, and bulk import contacts. It is essential for synchronizing contact data with CRMs, triggering custom automation events, building targeted segments, or performing large-scale list cleanups.

This skill guides the implementation of dynamic secrets using HashiCorp Vault. It focuses on generating short-lived, ephemeral credentials for services like databases (PostgreSQL, MySQL), AWS IAM, and PKI certificates. By automating credential generation, lease management, and rotation, it eliminates the risk associated with storing long-lived static secrets, ensuring compliance with zero-trust security models (PCI-DSS, NIST).

This skill helps diagnose, repair, and prevent complex Drizzle Kit database migration conflicts. It addresses issues arising from merging branches, rebasing, or PR updates involving generated SQL, snapshots, and journals. Use it to ensure stable schema evolution in multi-developer teams and harden CI/CD workflows.

A comprehensive skill for interacting with Weaviate vector databases. It enables advanced operations including semantic search, hybrid keyword querying, schema inspection, data exploration, collection creation, and bulk data import (CSV, JSON, PDF). Use this skill when you need to query data conceptually, retrieve specific raw objects, or manage the lifecycle of Weaviate collections.

Neon Functions provide long-running, stateful, serverless HTTP handlers deployed directly next to your Neon database branch. They are ideal for complex backend workloads that exceed traditional serverless limits, such as real-time WebSockets, Server-Sent Events (SSE) streaming, or sophisticated AI agents. Functions automatically inject the database connection URL and maintain state within the function scope, ensuring high performance and data proximity.

Neon Object Storage provides S3-compatible, branch-aware object storage directly integrated with your Neon Postgres project. It ensures that files (images, documents, user uploads) remain perfectly synchronized with the database schema across all development branches (dev, preview, staging, production). Use this skill when you need a single backend for both database rows and file assets, eliminating the need for separate cloud storage providers.

A comprehensive skill to diagnose and fix excessive Postgres egress (network data transfer) that leads to high cloud database bills. It guides the user through using `pg_stat_statements` to identify the most data-intensive queries. Key fixes include limiting selected columns (avoiding SELECT *), implementing pagination (LIMIT/OFFSET), and identifying high-frequency data sources for caching.

This comprehensive guide serves as a detailed reference for psql, the feature-rich interactive terminal for PostgreSQL. It covers connection methods (CLI flags, environment variables, ~/.pgpass), executing SQL queries, inspecting database objects using commands like \d, and managing data operations such as importing and exporting.