Data & Analytics

bg-szy Bundle

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.

bg-szy Bundle

Generate read-only MongoDB queries (find) or aggregation pipelines using natural language, with collection schema context and sample documents. Use this skill whenever the user asks to write, create, or generate MongoDB queries, wants to filter/query/aggregate data in MongoDB, asks "how do I query...", needs help with query syntax, or discusses finding/filtering/grouping MongoDB documents. Also use for translating SQL-like requests to MongoDB syntax. Does NOT handle Atlas Search ($search operator), vector/semantic search ($vectorSearch operator), fuzzy matching, autocomplete indexes, or relevance scoring - use search-and-ai for those. Does NOT analyze or optimize existing queries - use mongodb-query-optimizer for that. Does NOT handle aggregation pipelines that involve write operations. Requires MongoDB MCP server.

robsonkades Bundle

Choosing how code reaches the database — Table Data Gateway, Row Data Gateway, Active Record or Data Mapper — from the shape of the domain logic rather than from framework habit, and knowing what each one couples together. Use when a new module's persistence approach is being chosen, when entities carry both business rules and save() methods, when JPA is being applied to a schema that fights it, when SQL is scattered through service classes, when a "DAO" layer duplicates what the ORM already provides, when the domain model's shape is visibly dictated by the tables, when bulk or reporting work is being forced through an ORM, or when a team is arguing Active Record versus Data Mapper in the abstract. Does not cover where business logic lives (domain-logic-organization), the ORM's runtime behaviour — unit of work, identity map, lazy load (orm-behavioral-patterns), the column-level mapping decisions (orm-structural-mapping), or the collection-shaped abstraction over aggregates (repository-pattern).

robsonkades Bundle

Evidence-first triage and routing for database performance questions across SQL Server, MySQL/InnoDB, PostgreSQL, JDBC pools, ORM behavior, index portfolios, and bulk loading. Use when the symptom spans layers, the owning mechanism is unclear, or a database choice or migration needs structured comparison. This is a router; it does not replace the specialist skills that own a confirmed engine or mechanism.

robsonkades Bundle

Designing and diagnosing high-volume database ingestion from the JVM across PostgreSQL, MySQL, and SQL Server: JDBC batching and statement rewrite, native COPY/LOAD DATA/Bulk Copy, staging, transaction and partial-error semantics, idempotent restart, upsert races, logging, parallelism, and post-load validation. Use when a backfill, import, migration, or batch window is too slow or unsafe. Not routine ORM fetch/write tuning, which belongs to orm-fetch-and-batching-performance.

robsonkades Bundle

Designing and governing an index portfolio across SQL Server, MySQL/InnoDB, and PostgreSQL: deriving composite keys from a workload, equality/range/order trade-offs, covering and partial indexes, write amplification, redundant-index consolidation, engine-specific semantics, and safe production creation or removal. Use when changing schema indexes for several queries or reviewing a table's index set. Not the diagnosis of one slow statement, which belongs to sql-query-performance.

knuckles-team Bundle

Validate CSV, TSV, JSON, or JSON Lines data against an explicit JSON rule set and emit a redacted, machine-readable pass/fail report. Use when checking required columns, nullability, uniqueness, types, ranges, allowed values, or row-count expectations before analysis or ingestion. Do not use to repair data or infer unstated business rules.

knuckles-team Bundle

Use this skill whenever the user wants to connect to, query, or manage databases, including PostgreSQL, MySQL, and MS SQL Server (MSSQL). Requires setting up a connections.json file with credentials. Can execute SQL queries, inspect schemas, dump data, and repair broken tables depending on dialect.

knuckles-team Bundle

Profile a dataset, validate it against reviewed quality rules, and produce an owner-confirmed data dictionary. Use when a local CSV, TSV, JSON, or JSON Lines dataset must be assessed before analysis, ingestion, governance review, or handoff.

golemcloud Skill

Using MySQL from a Scala Golem agent through golem.host.Rdbms.Mysql. Use when the user asks to connect to MySQL, run SQL, or use MySQL from Scala agent code.

golemcloud Skill

Using golem:rdbms/postgres from a Rust Golem agent. Use when the user asks to connect to PostgreSQL, run SQL, execute a Postgres transaction, or use PostgreSQL from Rust agent code.

golemcloud Skill

Using Apache Ignite from a Scala Golem agent through golem.host.Rdbms.Ignite. Use when the user asks to connect to Apache Ignite 2, run SQL over Ignite, or use Ignite from Scala agent code.

golemcloud Skill

Uses MySQL from Effect-based Golem agents through @golemcloud/effect-golem/mysql. Use when connecting to MySQL, running SQL, or adding transactional MySQL operations to an Effect agent.

golemcloud Skill

Uses Apache Ignite 2 from an Effect-based Golem agent through @golemcloud/effect-golem/ignite2. Use when connecting to Ignite, running Ignite SQL, or adding transactional database operations to an Effect agent.

golemcloud Skill

Using PostgreSQL from a Scala Golem agent through golem.host.Rdbms.Postgres. Use when the user asks to connect to PostgreSQL, run SQL, or use Postgres from Scala agent code.

golemcloud Skill

Using golem:rdbms/mysql from a MoonBit Golem agent. Use when the user asks to connect to MySQL, run SQL, or use MySQL from MoonBit agent code.

golemcloud Skill

Using PostgreSQL from an Effect-based Golem agent through @golemcloud/effect-golem/postgres. Use when connecting to PostgreSQL, running SQL, or adding PostgreSQL transactions to an Effect Golem application.

golemcloud Skill

Using golem:rdbms/ignite2 from a MoonBit Golem agent. Use when the user asks to connect to Apache Ignite 2, run SQL over Ignite, or use Ignite from MoonBit agent code.

golemcloud Skill

Using golem:rdbms/postgres from a MoonBit Golem agent. Use when the user asks to connect to PostgreSQL, run SQL, or use PostgreSQL from MoonBit agent code.

ericrisco Bundle

Use when writing or reviewing advanced SQL query logic independent of any one engine — multi-table joins, window functions, CTEs including recursive ones, GROUP BY and GROUPING SETS aggregation, and set operations — or when a query returns too many rows, too few, or wrong totals. NOT engine internals, indexes or EXPLAIN (that is `postgresdb`), NOT MySQL config (that is `mysql`), NOT OLAP columnar specifics (that is `duckdb`).

xjli360 Bundle

Audit, diagnose, rewrite, creatively brief, test, and safely prepare updates for Amazon product detail pages using live marketplace and product-type requirements, verified product facts, Brand Analytics, Search Query Performance, Ads search terms, customer feedback, competitor observations, and optional third-party estimates. Use when asked to improve or evaluate Amazon titles, bullets, descriptions, backend search terms, attributes, images, video, A+ Content, Brand Story, variations, indexing, CTR, CVR, return prevention, ad-to-listing relevance, or to prepare an approval-ready Listings Items API PATCH. Default to draft and review; never invent product facts, copy competitors, manipulate reviews, or silently publish changes.

legendtkl Skill

Operate, configure, troubleshoot, and manage Apache Spark. Use for Apache Spark engineering tasks, day-to-day operations, and production support.

chuyentn Skill

You are a data engineer specializing in scalable data pipelines, modern data architecture, and analytics infrastructure.

chuyentn Skill

Analytics Tracking & Measurement Strategy

okhp3 Bundle

Evaluate a document, report, spreadsheet, hypothesis, decision memo, or Agent Skill with independent evidence review, conditional disruption, and evidence-based adjudication. Use when testing whether an artifact is trustworthy, sufficiently supported, safe to act on, or ready to release. Also activate for multi-agent review design, falsification passes, claim ledgers, or structured quality gates. Do not use as a substitute for a domain-specific statistical, legal, medical, or security review.

okhp3 Bundle

Safe refactoring guidance for legacy and existing codebases. Use when improving design without changing behavior, creating seams around hard dependencies, migrating null/string/generic exceptions to typed failure contracts, extracting a repository from direct SQL/ORM access, introducing Domain Events into legacy workflows, adding characterization tests, splitting large classes or methods, introducing value objects, replacing conditionals, or incrementally evolving code under risk.

okhp3 Bundle

OverKill Hill P³ database cartographer. Reverse-engineers and documents the live structure of Postgres, MySQL/MariaDB, MS SQL Server, SQLite, Oracle, and Microsoft Access databases via SQLAlchemy reflection or the right engine driver, producing a normalized schema inventory, a severity-classified (P1/P2/P3) diff against a locked design spec, and a Mermaid ER diagram handed to okhp3-mermaid-*/mermaid-diagrams for rendering. Use when asked to reverse-engineer, interrogate, document, or audit an existing database; verify a live build against a schema spec or data dictionary; generate an ER diagram from a real database connection; or check for schema drift. Also activate on "what does this database actually look like," "document this database," "audit against the spec," or "reflect this database's structure." Read-only by design -- not a data-quality profiler, not a migration generator, never writes to the target database.

contextgo Skill

Build rolling forecasts and bull/base/bear scenarios from explicit business drivers instead of opaque spreadsheet momentum.

contextgo Skill

Django security best practices, authentication, authorization, CSRF protection, SQL injection prevention, XSS prevention, and secure deployment configurations.

contextgo Skill

Turn CSV, JSON, spreadsheet extracts, tables, metrics, and report data into HyperFrames animated chart videos with data validation, chart recipes, labels, timing, renders, and QC.

lidge-jun Skill

X/Twitter API integration for posting tweets, threads, reading timelines, search, and analytics. Covers OAuth auth patterns, rate limits, and platform-native content posting.

lidge-jun Bundle

Excel XLSX create, read, edit, analyze. Triggers: Excel, .xlsx, spreadsheet, financial model, data analysis, pivot, chart.

lidge-jun Bundle

Execute read-only SQL queries against multiple PostgreSQL databases. Use when: (1) querying PostgreSQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

lidge-jun Skill

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

legendtkl Skill

Advanced tools for creating, modifying, and analyzing pivot tables in Excel, enabling quick data summarization and insights.

legendtkl Skill

A robust tool for cleaning, standardizing, and preparing CSV data files for analysis. Ideal for ensuring accuracy in datasets before use in reports or financial models.