Data & Analytics

brathod1432 Bundle

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

javimosch Skill

Explore Web3 on-chain data using Chainbase APIs. Use this skill when the user asks about blockchain data, token holders, wallet addresses, token prices, NFTs, ENS domains, transactions, DeFi portfolios, or any on-chain analytics. Triggers include: "top holders of", "who holds", "wallet address", "address labels", "token price", "token transfers", "NFT owners", "ENS domain", "on-chain data", "blockchain query", "SQL query on-chain", or any request to look up, analyze, or explore Web3/blockchain data across Ethereum, BSC, Polygon, Arbitrum, Optimism, Base, Avalanche, zkSync, and other EVM chains.

javimosch Skill

Pull daily Gumroad product/sales analytics safely (no raw PII persistence by default).

javimosch Skill

SQL Injection Testing

javimosch Skill

Query Google Analytics 4 (GA4) data directly via the Analytics Data API. Use when you need website analytics like top pages, traffic sources, sessions, users, conversions, bounce rate, or any GA4 metrics and dimensions. Supports custom date ranges, filtering, and multi-metric queries. Calls analyticsdata.googleapis.com directly with no third-party proxy.

brathod1432 Bundle

Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.

brathod1432 Bundle

Automate customer engagement workflows including broadcast triggers, message analytics, segment management, and newsletter tracking through Customer.io via Composio

javimosch Skill

Interact with Coda.io docs, tables, rows, pages, and automations via the Coda REST API v1. Use when the user wants to read, write, update, or delete data in Coda docs. Also use when they mention "Coda", "Coda doc", "Coda table", "Coda rows", "Coda API", "sync to Coda", "read from Coda", "write to Coda", "Coda automation", "Coda pages", "Coda formulas", "share Coda doc", or "Coda permissions". Covers docs, pages, tables, columns, rows, formulas, controls, folders, permissions, publishing, automations, and analytics.

javimosch Skill

Manage Cloudflare via API — DNS zones and records, page rules, SSL/TLS settings, caching, firewall rules, Workers, and analytics. Free tier includes DNS, CDN, DDoS protection, and SSL.

javimosch Skill

Publora API — schedule and publish social media posts across 11 platforms (X/Twitter, LinkedIn, Instagram, Threads, TikTok, YouTube, Facebook, Bluesky, Mastodon, Telegram, Pinterest). Use this skill when the user wants to post, schedule, draft, bulk-schedule, manage workspace users, configure webhooks, or retrieve LinkedIn analytics via Publora.

javimosch Skill

Personal X (Twitter) analytics — timeline engagement, mentions, follower tracking, read any tweet/thread, bookmarks, and combined briefings via X API v2. Cost-optimized with persistent local store and daily budget guards.

javimosch Skill

CSV Data Analyzer

amey-thakur Skill

Find and remove duplicate rows deterministically, keeping the record you meant to keep. Use when a table has accumulated duplicates or an import needs a clean unique set.

amey-thakur Skill

Diagnose and fix slow SQL with the query plan as evidence, not folklore. Use when a query is slow, a table scan appears, or database load climbs.

amey-thakur Skill

Place transformations before or after loading based on warehouse economics, governance, and reuse. Use when architecting a data platform or deciding where a transformation should live.

amey-thakur Skill

Write formulas that stay correct when rows are added and readable when someone else opens the file. Use when building any calculation in a spreadsheet.

amey-thakur Skill

Group users by a shared start and track them over time to see retention, behavior, and trends that aggregates hide. Use when a blended metric looks stable or improving but you suspect the underlying behavior is changing.

amey-thakur Skill

Read EXPLAIN ANALYZE output to find the real cause of a slow query and fix the right thing. Use when a query is slow and you need to know why before changing indexes or SQL.

amey-thakur Skill

Use CTEs to name intermediate steps so a complex query reads as a sequence rather than a nest, and know when they cost performance. Use when a query has grown into nested subqueries nobody can follow.

amey-thakur Skill

Handle cookies and similar storage so non-essential ones only load after consent and the banner reflects reality. Use when adding analytics, embeds, or any client-side storage on a website.

amey-thakur Skill

Eliminate SQL injection by sending data as bound parameters instead of concatenated query text, and auditing every raw-SQL escape hatch. Use when writing or reviewing code that builds database queries from variables.

amey-thakur Skill

Remove or blunt identifiers so a dataset can be analysed or shared without re-identifying people, and know when it is only pseudonymous. Use when preparing data for analytics, testing, sharing, or research.

amey-thakur Skill

Build charts that make the point clearly, choosing the type by the question and removing everything that does not carry meaning. Use when presenting spreadsheet data visually.

komunite Skill

Create a ecommerce analytics with structured process, quality checks, and system integration

komunite Skill

Yapılandırılmış süreç, kalite kontrolleri ve sistem entegrasyonu ile bir e-posta analitik panosu analiz edin ve oluşturun

amey-thakur Skill

Choose and write the right join so rows are neither lost nor multiplied, and know why a result set grew. Use when combining tables and the row count or the null columns look wrong.

amey-thakur Skill

Store, compare, and bucket timestamps with explicit time zones so reports do not drift by a day and ranges do not miss rows. Use when filtering by date, grouping by period, or storing an event time.

amey-thakur Skill

Reason about SQL nulls in comparisons, aggregates, joins, and uniqueness so absent values stop producing wrong or missing rows. Use when a query silently drops rows or a NOT IN returns nothing.

amey-thakur Skill

Group and aggregate correctly, understanding what GROUP BY collapses, how HAVING differs from WHERE, and how nulls and empty groups behave. Use when producing counts, sums, and per-group summaries.

amey-thakur Skill

Insert or update in one statement without races or lost updates, using the engine's conflict handling rather than check-then-write. Use when writing records that may or may not already exist.

amey-thakur Skill

Use window functions to rank, compare to neighbours, and compute running totals without collapsing rows or self-joining. Use when you need per-row context such as a rank, a previous value, or a running sum.

amey-thakur Skill

Minimize, classify, mask, and expire personal data so any leak or legal request reaches as little of it as possible. Use when designing storage, logging, or analytics that touch names, contacts, identifiers, or other personal data.

amey-thakur Skill

Reshape rows into columns and back, and know when the reshape belongs in SQL rather than in the reporting layer. Use when a report needs periods or categories as columns, or a wide table needs normalising.

amey-thakur Skill

Write SQL other people can review, modify, and trust, with clear structure, meaningful aliases, and stated assumptions. Use when a query will be read again by anyone, including you.

amey-thakur Skill

Walk hierarchies and graphs with recursive CTEs, with a termination condition and cycle protection so the query ends. Use when querying trees such as org charts, categories, threads, or dependency graphs.

amey-thakur Skill

Combine result sets with UNION, INTERSECT, and EXCEPT, and know when a join or an exists clause is the better tool. Use when merging or comparing two query results rather than two tables.