Databases

Connect your own data source to replace the demo unicorns data. Use when the user wants to use their own database URL or CSV file instead of the sample data. Triggers on requests to connect database, import CSV, change data source, use own data, or switch from demo data.

Enable live audience reactions and feedback during Slidev presentations with WebSocket-powered real-time updates

Implement robust error handling with user-friendly messages, fail-fast validation, specific exception types, centralized error boundaries, graceful degradation, retry strategies, and proper resource cleanup. Use this skill when writing try-catch blocks or exception handling code in any programming language (JavaScript/TypeScript, Python, Java, Go, Rust), implementing error boundaries in React (ErrorBoundary components) or similar error handling patterns in other frameworks (Vue error handlers, Angular ErrorHandler), handling API errors and HTTP error responses in fetch calls, Axios requests, or tRPC procedures, validating user input and function preconditions at the start of functions, creating custom error classes or exception types for specific failure scenarios (ValidationError, NotFoundError, UnauthorizedError, PaymentError), implementing retry logic with exponential backoff for external service calls, network requests, or database queries, ensuring proper resource cleanup in finally blocks or using langu

Create reversible, focused database migrations with proper naming, version control practices, and zero-downtime deployment considerations. Use this skill when creating or editing migration files in database/migrations/, when writing schema changes (creating/modifying tables, columns, indexes, foreign keys), when implementing migration rollback methods, when managing database version control, when adding or modifying indexes on large tables, or when separating schema changes from data migrations for safer deployments.

Design and implement the Viet K-Connect document generation template engine (DB-driven wizard schema + PDF renderSpec + history + Storage upload). Start with 2 templates and scale linearly to 50 without hardcoding.

Guide developers through database migration best practices including versioning, rollbacks, and zero-downtime strategies

Use when creating database migrations. Prevents data loss, downtime, and performance issues. Supports PostgreSQL, MySQL, SQLite. Python 3.8+

Use when working on web development tasks involving NextJS, React, TypeScript, Tailwind CSS, testing, deployment, APIs, databases, authentication, cloud infrastructure, or any modern web development stack. Provides access to 22 specialized web development skills covering frontend, backend, DevOps, and best practices.

Run tests before and after changes. Only add tests for complex logic, not boilerplate. Database tests matter most.

Multi-round web search with low-frequency query generation. Prioritize GitHub/StackOverflow for actionable code, extract AI Overview insights, and perform deep link analysis. Use proactively for complex problems requiring external knowledge or when stuck on implementation challenges.

Manages client case database in mis_documentos/ directory. Use when starting new legal work, creating documents, or generating proposals to find similar cases and maintain consistent style.

Persistent data cache with gap-filling for historical market data. Trigger when: (1) cache re-downloads complete data unnecessarily, (2) time-based cache expiry wastes API calls, (3) historical data needs incremental updates only.

Backend entity patterns - services with DI, Drizzle schemas (3-file pattern), ORPC routers, TypeIDs, neverthrow. Use when creating services, schemas, routers, or new entities.

Integrate Databricks Genie rooms as tools in agent workflows. Use when integrating Genie spaces with AI agents, querying Genie rooms programmatically via SDK or MCP, managing Genie conversations and polling, handling Genie API responses and errors, or building tool-calling agents that use Genie as a data source. Covers SDK patterns, MCP tool integration, conversation management, error handling, and performance optimization for Genie-based agent tools.

Guide for implementing Grafana Mimir - a horizontally scalable, highly available, multi-tenant TSDB for long-term storage of Prometheus metrics. Use when configuring Mimir on Kubernetes, setting up Azure/S3/GCS storage backends, troubleshooting authentication issues, or optimizing performance.

Database design, SQL, NoSQL, and data management patterns

SQLite best practices, optimization, and common patterns for Go applications

Build PRISMA 2020-compliant systematic literature review systems with RAG-powered analysis in VS Code. Use when researcher needs automated paper retrieval (Semantic Scholar, OpenAlex, arXiv), AI-assisted PRISMA screening (50% or 90% threshold), vector database creation (ChromaDB), or research conversation interface. Supports knowledge_repository (comprehensive, 15K+ papers, teaching/exploration) and systematic_review (publication-quality, 50-300 papers, meta-analysis) modes. Conversation-first workflow with 7 stages.

Qdrant vector database REST API via curl. Use this skill to store, search, and manage vector embeddings.

Guide developers through PostgreSQL setup, connection configuration, query patterns, and best practices