Claude Skills by thedixitjain

Operate a Podium webhook receiver that survives the delivery-side failures — forged events without signature verification, replay attacks against a stateless handler, duplicate processing from Podium's 24h retry policy, lost events with no dead-letter queue, out-of-order batch deliveries, and timing-attack-vulnerable HMAC compares. Use when building a webhook endpoint for call transcripts, webchat events, conversation lifecycle, or review notifications; hardening an existing handler that proc...

Use when positioning an ACM PODS submission against the database-theory literature across PODS, ICDT, LICS, and the journals (TODS, LMCS, JACM, VLDBJ), writing delta-first contrast that compares results rather than cataloging citations, keeping self-citations double-anonymous, and handling concurrent, arXiv-preprint, and prior-version overlap.

Fast in-memory DataFrame library for datasets that fit in RAM. Use when pandas is too slow but data still fits in memory. Lazy evaluation, parallel execution, Apache Arrow backend. Best for 1-100GB datasets, ETL pipelines, faster pandas replacement. For larger-than-RAM data use dask or vaex.

Use when executing and reporting the analysis for a Production and Operations Management (POM) manuscript — proving and numerically illustrating an analytical model, or estimating and validating an empirical / behavioral / operations-data-science study. Executes and reports; it does not pick the method (pom-methods) or frame the contribution (pom-contribution-framing).

Use when executing and reporting the analysis for a Population and Development Review (PDR, Wiley / Population Council) manuscript so it survives expert, double-anonymized review — correct rate construction, honest uncertainty, and demographic methods done right, with the development/policy meaning of each quantity made clear. Guides analysis and reporting norms; it does not fabricate results.

Use when preparing the data-availability statement and reproducibility materials for a Population and Development Review (PDR, Wiley / Population Council) manuscript. PDR follows Wiley's data-sharing and research-integrity expectations — a data availability statement, ORCID, and reproducible, well-documented materials deposited in a FAIR repository (verify current policy). Covers restricted-data exemptions. Prepares the materials; it does not waive requirements.

Use when executing and reporting the analysis for a Public Opinion Quarterly (POQ) manuscript so it survives expert, double-blind review — design-based inference that respects survey weights, strata, and clusters, honest uncertainty, robustness, and reproducibility. POQ verifies that code reproduces every table and figure. Guides analysis norms; it does not fabricate results.

Use when running the final pre-submission preflight for Public Opinion Quarterly (POQ) via ScholarOne Manuscripts — submission-type selection, double-blind preparation, word caps, AAPOR-standard Appendix A disclosure, the Data Availability Statement, and the replication package. Final checks; it does not draft content.

Use when preparing the transparency materials for a Public Opinion Quarterly (POQ) manuscript — the AAPOR-standard \"Appendix A: Disclosure Elements\", the replication package deposited to POQ's Harvard Dataverse, and the Data Availability Statement. POQ requires materials that reproduce exactly all published tables and figures, archived before typesetting. Prepares the materials; it does not waive requirements.

Audit a local or remote tabular file (CSV/TSV) for common data quality issues — schema, nulls, types, duplicates. Read-only. Use when a dataset needs a quality check before publishing, or a showcase renders wrong (blank cells, garbled numbers, an unsortable date column) and the cause needs isolating.

Wire a scaffolded PortalJS portal to a CKAN backend over its API. Generates a tiny server-side fetch client (no runtime dependency) and feeds the /search catalog and /@namespace/slug showcases from CKAN instead of datasets.json. Use when connecting an existing portal to a live CKAN instance instead of a static manifest.

Define a dataset's metadata profile — infer a Frictionless Table Schema from its data, add Data Package metadata (license, sources, keywords), and write it into datasets.json so the showcase renders a typed field table. Extend or customize via the L0-L3 profile ladder. Use when a registered dataset needs field types, constraints, or catalog metadata before publishing.

Migrate (harvest) datasets between open-data platforms. Reads CKAN, a DCAT-US /data.json catalog (DKAN, ArcGIS Hub, data.gov), a DCAT / DCAT-AP RDF feed (JSON-LD, Turtle, or RDF/XML), Socrata, OpenDataSoft, or an ArcGIS FeatureServer, and writes them to a static PortalJS catalog or pushes them into a CKAN instance over its API. Use when moving datasets from an external open-data platform into a PortalJS portal, or bridging one CKAN instance to another.

Perform recon, persistence, privilege escalation, and data search via the Microsoft Graph API using GraphRunner.

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Sorgu optimizasyonu, şema tasarımı, indeksleme ve güvenlik için PostgreSQL veritabanı kalıpları. Supabase en iyi uygulamalarına dayanır.

用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Patrones de base de datos PostgreSQL para optimización de consultas, diseño de esquemas, indexación y seguridad. Basado en las buenas prácticas de Supabase.

> PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth write protection.

PostgreSQL interactive terminal (psql) reference and usage guide. Use this skill whenever the user mentions psql, PostgreSQL command-line client, backslash commands, meta-commands, \\d commands, database inspection, SQL scripting in PostgreSQL, importing/exporting data with psql, \\copy,...

PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem.

Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

'Install and configure PostHog SDKs with authentication. Use when setting up posthog-js (browser), posthog-node (server), or configuring API keys for a new PostHog integration. Trigger: \"install posthog\", \"setup posthog\", \"posthog auth\", \"configure posthog API key\", \"posthog init\". '

'Handle PostHog API rate limits with exponential backoff, request queuing, and understanding PostHog''s actual limit tiers (240/min analytics, 600/min flags). Trigger: \"posthog rate limit\", \"posthog throttling\", \"posthog 429\", \"posthog retry\", \"posthog backoff\", \"posthog too many requests\". '

'Implement PostHog webhook destinations, Action-triggered notifications, and event querying via the Events API and HogQL. Trigger: \"posthog webhook\", \"posthog events API\", \"posthog actions\", \"posthog notifications\", \"posthog event query\", \"posthog HogQL\". '

Generate complete, import-ready Postman Collection v2.1 JSON files from natural language API descriptions or cURL commands. Use this skill whenever the user describes an API in plain English (\"I have a REST API with these endpoints...\"), pastes cURL commands, or asks to \"create a...

'Build prefect flow builder operations. Auto-activating skill for Data Pipelines. Triggers on: prefect flow builder, prefect flow builder Part of the Data Pipelines skill category. Use when working with prefect flow builder functionality. Trigger with phrases like \"prefect flow builder\", \"prefect builder\", \"prefect\". '

'Process automate data cleaning, transformation, and validation for ML tasks. Use when requesting \"preprocess data\", \"clean data\", \"ETL pipeline\", or \"data transformation\". Trigger with relevant phrases based on skill purpose. '

Draft and publish AI-powered press releases — submit a URL + notes, get a live release page instantly. Free, no API key required.

Automate Prisma tasks via Rube MCP (Composio). Always search tools first for current schemas.

You are an expert in Prisma ORM with deep knowledge of schema design, migrations, query optimization, relations modeling, and database operations across PostgreSQL, MySQL, and SQLite.

Prisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like updateMany returning count not records, $transaction timeouts, migrate dev resetting the DB, @updatedAt skipped on bulk writes, and serverless connection exhaustion.

'Configure with prisma schema helper operations. Auto-activating skill for Backend Development. Triggers on: prisma schema helper, prisma schema helper Part of the Backend Development skill category. Use when working with prisma schema helper functionality. Trigger with phrases like \"prisma schema helper\", \"prisma helper\", \"prisma\". '

Full-text search across all of the user's GitHub repos (including private ones) using a local mirror and ripgrep. Use for \"where did I put X\", \"which repo has X\", or any search spanning the user's repos - gh search code / the REST API cannot reliably search private repos.

'Optimize bulk API requests with batching, throttling, and parallel execution. Use when processing bulk API operations efficiently. Trigger with phrases like \"process bulk requests\", \"batch API calls\", or \"handle batch operations\". '

\"Procore common errors \\u2014 construction management platform integration.\\n\\ Use when working with Procore API for project management, RFIs, or submittals.\\n\\ Trigger with phrases like \\\"procore common errors\\\", \\\"procore-common-errors\\\".\\n\"

\"Procore core workflow a \\u2014 construction management platform integration.\\n\\ Use when working with Procore API for project management, RFIs, or submittals.\\n\\ Trigger with phrases like \\\"procore core workflow a\\\", \\\"procore-core-workflow-a\\\"\\ .\\n\"

\"Procore core workflow b \\u2014 construction management platform integration.\\n\\ Use when working with Procore API for project management, RFIs, or submittals.\\n\\ Trigger with phrases like \\\"procore core workflow b\\\", \\\"procore-core-workflow-b\\\"\\ .\\n\"

\"Procore cost tuning \\u2014 construction management platform integration.\\n\\ Use when working with Procore API for project management, RFIs, or submittals.\\n\\ Trigger with phrases like \\\"procore cost tuning\\\", \\\"procore-cost-tuning\\\".\\n\"

\"Procore data handling \\u2014 construction management platform integration.\\n\\ Use when working with Procore API for project management, RFIs, or submittals.\\n\\ Trigger with phrases like \\\"procore data handling\\\", \\\"procore-data-handling\\\".\\n\"

\"Procore enterprise rbac \\u2014 construction management platform integration.\\n\\ Use when working with Procore API for project management, RFIs, or submittals.\\n\\ Trigger with phrases like \\\"procore enterprise rbac\\\", \\\"procore-enterprise-rbac\\\"\\ .\\n\"

\"Procore hello world \\u2014 construction management platform integration.\\n\\ Use when working with Procore API for project management, RFIs, or submittals.\\n\\ Trigger with phrases like \\\"procore hello world\\\", \\\"procore-hello-world\\\".\\n\"

\"Procore install auth \\u2014 construction management platform integration.\\n\\ Use when working with Procore API for project management, RFIs, or submittals.\\n\\ Trigger with phrases like \\\"procore install auth\\\", \\\"procore-install-auth\\\".\\n\"