Data & Analytics

jsamuelsen11 Skill

This skill should be used when working on MySQL databases, writing SQL schemas, creating tables, designing database architecture, or reviewing MySQL code.

lawless-m Bundle

Use when querying or writing any RI database — Exportmaster (DBISAM sem01/sem04), PostgreSQL x3rocs, X3/Sage1000 SQL Server, keycloak MySQL, or Parquet. DuckDB is the primary read path.

lawless-m Skill

Use when uploading/downloading files to RI's SharePoint Online sites, updating Excel tracker cells, or normalizing pasted share links.

sunnypatneedi Skill

Build habit-forming products using Hook Model (trigger-action-reward-investment), cohort analysis, feature adoption tracking, and re-engagement strategies. Turn one-time users into daily/weekly active users with sustainable retention mechanics.

sunnypatneedi Skill

Design database schemas that scale from prototype to production. Use when planning data models, designing tables, optimizing queries, or migrating schemas. Covers normalization, indexing, partitioning, and evolution strategies for SQL and NoSQL databases.

jsamuelsen11 Skill

This skill should be used when working on SQLite databases, writing SQL schemas, configuring PRAGMAs, using FTS5, or designing embedded database schemas.

jsamuelsen11 Skill

This skill should be used when working on PostgreSQL databases, writing SQL schemas, creating tables, designing database architecture, or reviewing PostgreSQL code.

proxiblue Skill

Security audit workflow for Magento custom code. Invokable standalone (audit the whole project's custom code) OR chained from /proxiblue-skills:workflow-build-feature as a quality gate (audit only the current branch's diff). Checks for: SQL injection (raw query strings without binding, $resource->getConnection()->query() with concatenation), XSS (unescaped output in .phtml, missing escapeHtml/escapeUrl), CSRF (form keys, missing form_key inputs), authentication bypass (admin controllers missing _isAllowed), file upload risks, command injection (shell_exec / exec / system / passthru / `backticks` with user input), insecure deserialization (unserialize on user data), hardcoded secrets/credentials, insecure direct object reference (route params reaching $resource->load without ACL), CSP violations, weak crypto. Returns structured STATUS (PASS / PASS-WITH-NOTES / BLOCKING) + findings list with file:line + severity + suggested fix. Uses gitnexus impact() to chase callers of risky symbols across the project. Compos

wesleysmits Skill

Scans code for security vulnerabilities and unsafe patterns. Use when the user asks about security, mentions OWASP, credentials, secrets, XSS, SQL injection, or wants to audit code for threats.

haru-llc Skill

Excelスプレッドシート(.xlsx)の読み取り、作成、編集を行うスキル。数式、チャート、データ変換に対応。

stateset Bundle

Run commerce analytics, metrics, and forecasts. Use when running `stateset-analytics` or requesting sales, customer, inventory, or demand insights and trend analysis.

stateset Bundle

Manage inbound goods receiving, inspection, and put-away. Use when processing purchase order arrivals, transfers, or return receipts into warehouse locations.

stateset Bundle

Manage warehouses, locations, and inventory movements. Use when setting up warehouses, creating zones/bins, moving stock between locations, or tracking location-level inventory.

stateset Bundle

Manage fulfillment waves, pick tasks, pack tasks, and ship tasks. Use when processing outbound orders through the warehouse pick-pack-ship workflow.

olehsvyrydov Bundle

Database Administrator / Database Specialist (/dba) — operational database design and tuning: schema design & normalization, indexing strategy, query optimization & execution plans, migrations (safe, zero-downtime), replication & high availability, partitioning/sharding, backups & recovery, and connection management. Covers Postgres, MySQL, and similar OLTP engines. Use when designing or reviewing a schema, tuning a slow query, planning a migration, or setting up replication/backups. Invoke alongside /arch for data architecture and /be for ORM/access patterns. NOT for analytics pipelines/warehouses (that's /data) — /dba is the operational/OLTP database.

olehsvyrydov Bundle

SQL and relational-database engineering with dialect branches for Postgres, MySQL, Oracle, and SQLite. Load whenever writing, editing, or reviewing SQL: a .sql file, a schema migration, a raw query embedded in application code, index/EXPLAIN/tuning work, or stored procedures/triggers. NOT for ORM entity mapping where no SQL is written (that is /be), and NOT for analytics/warehouse modeling (that is /data).

olehsvyrydov Bundle

Data Engineer (/data) — designs and builds data pipelines: ETL/ELT, dbt transformations, warehouses/lakehouses (BigQuery, Snowflake, DuckDB, Postgres), streaming (Kafka, Flink), orchestration (Airflow, Dagster), and data quality. Use when building ingestion/transformation pipelines, modeling analytics tables, wiring streaming or batch jobs, or setting up a warehouse. Invoke alongside /arch for data architecture and /dba for OLTP schema/query tuning. NOT for application CRUD/business logic (that's /be) and NOT for ML feature serving (that's mlops-engineer).

darthmolen Skill

Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. Masters advanced SQL features, indexing strategies, and data warehousing patterns.

abhattacherjee Skill

Vault health diagnostics and usage analytics — signal coverage, access patterns, importance distribution, top accessed notes. Saves report to vault for trend tracking. Use when: (1) /vault-stats command, (2) user wants to check vault health, (3) user wants to see access patterns or signal effectiveness.

eriklieben Bundle

Security checklist for C#/.NET backend (ASP.NET Core, EF Core, Event Sourcing). Covers secrets management, input validation, SQL injection, authentication, authorization, rate limiting, security headers, sensitive data handling, Problem Details (RFC 7807), and event sourcing security. Invoked via /dev-security (unified entry point) — not directly.

boltaai Skill

Read what actually happened — reach, engagement, follower movement, which posts worked — and say what to do about it. Use this skill when the user asks "how did we do", "show my analytics", "what performed best", "is this working", "weekly recap", "which platform is growing", or wants performance interpreted rather than dumped. Read-only: it never creates, schedules or publishes anything. To act on the findings, hand off to social-publishing.

boltaai Skill

Work the Bolta review and approval queues. Use this skill when the user asks "what needs my review", "show the approval queue", "approve pending posts", "review my content", "what's waiting for approval", "clear my review queue", "anything to approve", "approve the agent drafts", "any replies to send", "send that reply", or wants to triage, approve, reject, edit-and-send, or push content into review. Handles ALL inbox sources: the standard review queue, the agent-produced recurring queue, hunter reply drafts (edit + send), and agent reports. This skill is the standing inbox — triage whatever is already waiting. To trigger a run and then review its output in one loop, run the routine first with bolta-setup's routine flow. Not for writing new content (use bolta-draft-post) or reading analytics (use bolta-analytics-report).

boltaai Skill

Turn a brand's best organic posts into voice-true Meta ad creative. Use this skill when the user asks "turn my best posts into ads", "what should I boost", "refresh my ad creative", "organic to paid", "which posts should I promote", or wants their organic winners fed into Facebook/Instagram advertising. Works best with BOTH the Bolta connector and Meta's Ads AI Connector (mcp.facebook.com/ads) in the session, but degrades gracefully with either one alone. Read-only on Meta — this skill NEVER creates or edits campaigns, ad sets, ads, or budgets. For pure organic analytics use bolta-analytics-report; for organic drafting use bolta-draft-post.

boltaai Skill

Report on social-media performance from Bolta's analytics. Use this skill when the user asks "how are my posts doing", "how did that post do", "show my analytics", "performance report", "how did LinkedIn do this month", "which account is growing", "engagement over the last 30 days", "what's my best-performing account/post", or wants any rollup, comparison, or trend of reach/engagement across their posts or connected accounts. Not for reading the review queue (use bolta-review-queue) or writing content (use bolta-draft-post).

boltaai Bundle

Retrieve performance metrics for published posts including likes, comments, shares, views, and engagement rate

boltaai Skill

Inspect connected social accounts and manage social buckets — named groups of accounts for one-shot multi-account publishing. Use this skill when the user asks "what's connected", "which accounts do I have", "show my social accounts", "create a bucket", "make a Launch Team bucket with my LinkedIn and X", "add my Instagram to the launch bucket", "rename that bucket", or says "post to my <bucket> bucket" and you need to resolve the bucket's member accounts. Connecting a new account happens in the user's browser — hand them a link via get-connect-link. Not for drafting content (use bolta-draft-post) or analytics (use bolta-analytics-report).

boltaai Bundle

Retrieve audience demographics, behavior patterns, and engagement trends for data-driven content strategy

boltaai Bundle

Analyze historical performance to recommend optimal posting schedule based on when YOUR specific audience is most engaged

armanzeroeight Skill

Design ETL/ELT pipelines with proper orchestration, error handling, and monitoring. Use when building data pipelines, designing data workflows, or implementing data transformations.

armanzeroeight Skill

Optimize SQL queries for performance with indexing strategies, query rewriting, and execution plan analysis. Use when queries are slow, optimizing database performance, or analyzing query execution.

i3ringit Skill

Use this agent when you need to perform security audits, vulnerability assessments, or security reviews of code. This includes checking for common security vulnerabilities, validating input handling, reviewing authentication/authorization implementations, scanning for hardcoded secrets, and ensuring OWASP compliance. <example>Context: The user wants to ensure their newly implemented API endpoints are secure before deployment.\nuser: "I've just finished implementing the user authentication endpoints. Can you check them for security issues?"\nassistant: "I'll use the security-sentinel agent to perform a comprehensive security review of your authentication endpoints."\n<commentary>Since the user is asking for a security review of authentication code, use the security-sentinel agent to scan for vulnerabilities and ensure secure implementation.</commentary></example> <example>Context: The user is concerned about potential SQL injection vulnerabilities in their database queries.\nuser: "I'm worried about SQL inject

i3ringit Skill

Use this agent when you need to analyze code for performance issues, optimize algorithms, identify bottlenecks, or ensure scalability. This includes reviewing database queries, memory usage, caching strategies, and overall system performance. The agent should be invoked after implementing features or when performance concerns arise.\n\n<example>\nContext: The user has just implemented a new feature that processes user data.\nuser: "I've implemented the user analytics feature. Can you check if it will scale?"\nassistant: "I'll use the performance-oracle agent to analyze the scalability and performance characteristics of your implementation."\n<commentary>\nSince the user is concerned about scalability, use the Task tool to launch the performance-oracle agent to analyze the code for performance issues.\n</commentary>\n</example>\n\n<example>\nContext: The user is experiencing slow API responses.\nuser: "The API endpoint for fetching reports is taking over 2 seconds to respond"\nassistant: "Let me invoke the per

dmccreary Bundle

Installs and configures intelligent-textbook infrastructure - scaffold a brand-new MkDocs Material textbook (init textbook), install any of 40 features (math, mascot, learning graph viewer, Google Analytics GA4, custom 404, kanban board), and generate book metrics. Routes to the appropriate installation guide.

dmccreary Skill

Wires Google Analytics 4 into an MkDocs Material site — creates a GA4 property, writes the Measurement ID into mkdocs.yml, verifies the tag, and deploys. Use when adding analytics to a textbook for the first time.

spjoshis Skill

Master Excel for data analysis with pivot tables, formulas, Power Query, and advanced Excel techniques.

futuregerald Bundle

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.