Data & Analytics

projectious-work Bundle

SQL query patterns, schema design, and optimization — joins, CTEs, window functions, indexing, and anti-patterns. Use when writing or optimizing SQL queries, designing or reviewing a relational schema, reading EXPLAIN plans, choosing indexes, or implementing pagination, deduplication, or analytical queries.

projectious-work Skill

SQL style — snake_case, singular tables, named constraints, one-clause-per-line formatting. Use when writing or reviewing SQL, designing schemas, or naming tables, columns, constraints, and migrations.

iterationlayer Skill

Extract shipment details, item quantities, and delivery confirmation data from warehouse delivery notes and goods received notes.

iterationlayer Skill

Generate an XLSX billing statement with a merged company header, subscription line items, overages, credits, and subtotal/tax/total formulas.

iterationlayer Skill

Generate a formatted XLSX spreadsheet with sales data, currency formatting, and bold headers.

iterationlayer Skill

Generate an XLSX invoice with company info, line items, subtotal/tax/total formulas, and currency formatting.

iterationlayer Skill

Extract key terms from multiple signed contracts and build a structured XLSX contract register tracking parties, dates, value, and renewal terms.

iterationlayer Skill

Extract structured fields from warehouse receipt documents.

iterationlayer Skill

Extract structured data from multiple invoice PDFs in one call, then pipe the results directly into an XLSX accounts payable tracker.

iterationlayer Skill

Extract key terms from a non-disclosure agreement, then generate a compliance checklist spreadsheet tracking obligations and deadlines.

iterationlayer Skill

Extract merchant, date, amount, and category from receipt photos and PDFs in one call, then generate an XLSX expense report with a totals row.

iterationlayer Skill

Generate a multi-sheet XLSX report tracking API usage, credit consumption, and billing across multiple agency clients.

iterationlayer Skill

Extract every product from a supplier catalog PDF — SKUs, names, prices, MOQs — and generate a ready-to-import XLSX in two API calls.

iterationlayer Skill

Extract traffic violation data from fine notices, then generate a spreadsheet summarizing all violations for fleet management.

iterationlayer Skill

Extract applicant details from rental application PDFs and generate a side-by-side XLSX for comparing income, employment, and move-in dates.

iterationlayer Skill

Extract HS codes, declared values, and duty amounts from customs declaration documents, then generate an XLSX import duty log.

eliferjunior Skill

Process real-time data streams with Apache Flink. Use when a user asks to build real-time analytics, process event streams with low latency, implement complex event processing, or run stateful stream processing at scale.

eliferjunior Skill

MySQL is the world's most popular open-source relational database management system. Learn installation, SQL queries, indexing strategies, replication setup, and client integration with Node.js (mysql2) and Python (mysql-connector).

eliferjunior Skill

Track website analytics with Umami — privacy-focused, open-source Google Analytics alternative. Use when someone asks to "track website analytics", "Umami", "privacy-friendly analytics", "self-hosted analytics", "GDPR analytics", "replace Google Analytics", or "website traffic tracking without cookies". Covers setup, event tracking, custom properties, API, and self-hosting.

eliferjunior Skill

DuckDB is an in-process analytical database that runs embedded inside your application with zero external dependencies. It can query CSV, Parquet, and JSON files directly without loading them into tables first, making it ideal for local data exploration, ETL pipelines, and analytical workloads where spinning up a server is overkill.

eliferjunior Skill

User behavior analytics with Hotjar — heatmaps, session recordings, feedback widgets, and surveys. Covers script installation, JavaScript API for custom events and user attributes, survey API, integration with analytics platforms like Google Analytics and Mixpanel, and privacy controls. Use when tasks involve understanding how users interact with a page visually, debugging UX issues with session recordings, or collecting user feedback with surveys.

eliferjunior Skill

Write type-safe SQL with Kysely query builder. Use when a user asks to write raw SQL with TypeScript safety, build queries without an ORM, use a lightweight SQL builder, or migrate from Knex with type safety.

eliferjunior Skill

Expert guidance for Malloy, the experimental data language from Google that replaces SQL for analytics with a composable, reusable, and more readable syntax. Helps developers write Malloy models, build nested queries, and explore data with Malloy's VS Code extension and notebook interface.

eliferjunior Skill

Build database applications with NocoDB, the open-source Airtable alternative. Use when a user asks to create spreadsheet views of databases, build forms, configure automations, use the NocoDB API, or self-host NocoDB.

eliferjunior Skill

Assists with loading, cleaning, transforming, and analyzing tabular data using pandas. Use when importing CSV/Excel/SQL data, handling missing values, performing groupby aggregations, merging datasets, working with time series, or building analysis-ready datasets. Trigger words: pandas, dataframe, csv, groupby, merge, time series, data cleaning.

eliferjunior Skill

Polars is a blazingly fast DataFrame library written in Rust with a Python API. Learn eager and lazy evaluation, expressions, groupby, joins, and how Polars outperforms pandas for large datasets through parallel execution.

eliferjunior Skill

Detect and exploit SQL injection with sqlmap. Use when a user asks to test for SQL injection, extract database contents, bypass authentication via SQLi, automate injection testing, or dump database schemas.

eliferjunior Skill

Expert guidance for Trieve, the all-in-one search infrastructure that combines full-text, semantic, and hybrid search with built-in RAG capabilities. Helps developers implement production search with chunking, re-ranking, recommendations, and analytics without managing vector databases or embedding models.

eliferjunior Skill

Build database-powered applications with Baserow, the open-source no-code database. Use when a user asks to create spreadsheet databases, build API-connected workflows, manage relational data, or self-host Baserow as an Airtable alternative.

eliferjunior Skill

Generate and parse Excel spreadsheets with ExcelJS — create workbooks with multiple sheets, styled cells, formulas, charts, images, and conditional formatting. Use when tasks involve exporting application data to .xlsx, building financial reports, parsing uploaded spreadsheets, or creating data import/export pipelines.

eliferjunior Skill

Expert guidance for Pandera, the Python library for validating pandas and Polars DataFrames with expressive schemas. Helps developers define data contracts, validate data pipelines, and catch data quality issues before they corrupt downstream systems.

eliferjunior Skill

Collect and route customer data with Segment — customer data platform (CDP) that sends events to any destination. Use when someone asks to "track user events across tools", "Segment", "customer data platform", "send events to multiple analytics tools", "CDP", or "unify analytics across Mixpanel/ Amplitude/BigQuery". Covers identify, track, page, group, and destination routing.

eliferjunior Skill

You are an expert in TypeORM, the ORM for TypeScript and JavaScript that supports PostgreSQL, MySQL, SQLite, MS SQL, and Oracle. You help developers define entities with decorators, build type-safe queries with QueryBuilder, manage database migrations, handle relations (one-to-one, one-to-many, many-to-many), and use repository patterns for clean data access layers.

eliferjunior Skill

LLM observability proxy that sits between your app and LLM providers. Logs every request, enables caching, rate limiting, and provides cost analytics. Works with OpenAI, Anthropic, and other providers with a one-line integration change.

eliferjunior Skill

Create beautiful developer documentation with Mintlify — AI-powered docs platform. Use when someone asks to "create documentation site", "Mintlify", "developer docs", "API documentation", "beautiful docs like Stripe", or "documentation platform with AI search". Covers page creation, API reference generation, components, analytics, and AI chat.

eliferjunior Skill

Build real-time analytics APIs with Tinybird — ingest millions of events and query with SQL over HTTP. Use when someone asks to "build analytics API", "Tinybird", "real-time analytics", "event analytics", "ClickHouse as a service", "usage metering", or "product analytics backend". Covers data ingestion, SQL pipes, API endpoints, and real-time dashboards.