Find the right table in a warehouse with thousands of them
Ask "where is customer email stored?" and get an answer, not a 50-page data dictionary. Scans your warehouse metadata and, where allowed, profiles tables to build a searchable semantic index so you stop wasting hours hunting for the right data.
Create a skill called "Schema Scout". Connect to my data warehouse and build a searchable catalog. For each table, record: name, schema, row count, column names and types, freshness (last updated), and any existing descriptions or comments. Where access allows, include sample values or profiling stats that help explain what the table contains. Generate plain-English descriptions for columns based on their names and data patterns (e.g., "cust_email" → "Customer email address, VARCHAR, 98% populated"). Build a semantic index so I can ask questions like "Where is customer email stored?" or "Which table has order revenue?" and get direct answers. Detect tables that appear to contain overlapping data and recommend canonical sources. Update the index on a weekly schedule.
Large data warehouses have thousands of tables with names like `stg_crm_contacts_v2`
and `dim_customer_legacy_backup`. Nobody knows which customer table is canonical.
This skill builds a semantic index from your warehouse metadata so you can search
in plain English.
Documentation that updates itself when the data changes
Auto-generates and maintains documentation for your data models, SQL queries, and warehouse schemas. When the schema changes, the docs update. When a query is modified, the description stays current. No more stale Confluence pages.
Turn spaghetti SQL into readable, documented code
Paste any monster SQL query — 400 lines of nested CTEs with no comments — and get back a documented version with plain-English explanations, a dependency diagram, and suggestions for modularization.
Wikipedia-grade AI pattern removal
Comprehensive AI writing cleanup based on Wikipedia's WikiProject AI Cleanup guidelines. Catches 24+ distinct patterns including inflated symbolism, em dash overuse, rule of three, copula avoidance, and sycophantic tone.
Update pricing across all your Airbnb listings without clicking through each one
Automate bulk rate changes across multiple Airbnb listings using your Claw. Useful for seasonal pricing updates, last-minute discounts, or syncing rates after a change in your hosting strategy.