Skill UI

A comprehensive, expert-level skill for designing, analyzing, and optimizing robust database schemas. It covers normalization, index tuning, choosing between SQL/NoSQL, and implementing zero-downtime data migrations. Provides systematic workflows for schema analysis, performance modeling, and advanced SQL pattern generation.

Automates guidance for date range analytics, covering SQL, visualization, statistics, and BI, with code generation and validation to support data analytics workflows.

This comprehensive playbook guides Series A+ B2B SaaS companies on international scaling. It covers the full demand generation lifecycle, from TOFU awareness campaigns using SEO and paid social (LinkedIn, Google, Meta), to MOFU lead nurturing, and BOFU pipeline conversion. It details core KPIs (CAC, MQL/SQL), multi-channel optimization, technical SEO best practices, and strategic partnership building for sustained growth.

This guide details how to implement HashiCorp Vault's dynamic secrets engine. It automates the generation, lease management, and rotation of short-lived credentials for databases (e.g., PostgreSQL, MySQL), AWS IAM, and PKI certificates. This method eliminates the use of static, hardcoded secrets, enforcing zero-trust principles and meeting stringent compliance mandates like PCI-DSS.

This skill is designed for understanding complex database structures. It allows users to list all available tables, intelligently filter relevant tables based on natural language queries, retrieve detailed schemas (columns, types, primary/foreign keys), and map inter-table relationships. It culminates in generating the M-Schema format, which is essential for accurately preparing the context needed for advanced SQL query generation.

This expert acts as a dedicated data analysis partner for Product Managers. It helps users explore data, write complex queries (e.g., SQL, BigQuery), analyze key metrics, and create structured dashboards. Use this tool when you need to derive actionable insights from complex datasets, compare user cohorts, or understand product performance trends to inform critical business decisions.

This skill automatically converts structured data specifications (such as CSV, JSON schemas, SQL DDL, or Protobuf definitions) into functional, production-ready code. It generates complete models, validation logic, full CRUD API endpoints, and unit tests in multiple languages (Python, TypeScript, Go, etc.), significantly reducing boilerplate coding time and ensuring type safety.

This skill allows for the generation and execution of complex, optimized SQL queries to derive deep business insights. It supports sophisticated data workflows, including multi-table joins, multi-dimensional analysis (e.g., trend analysis, attribution modeling, comparative analysis), and subsequent recommendations for appropriate data visualizations (e.g., line charts, waterfall charts). It goes beyond simple SELECT statements by planning the query structure, handling schema relationships, and ensuring adherence to best practices.

Generate data analysis reports by exploring database tables, running multidimensional SQL queries, performing deep attribution analysis, and outputting dynamic HTML visual reports with ECharts for business, trend, and KPI scenarios.

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

Create a new Rails project with an opinionated stack including PostgreSQL, Inertia.js, React, Vite, Tailwind CSS, Sidekiq, and Redis. Provides guidance on project generation, conventions, testing, and verification for a fresh Rails app.

This skill provides a complete production-ready Docker setup for Odoo ERP. It includes PostgreSQL database configuration, persistent volume management, environment variable handling, and optional Nginx reverse proxy with SSL support. Suitable for local development, VPS deployment, and troubleshooting container issues. Covers docker-compose.yml generation and odoo.conf tuning for optimal performance.