SQL in Data & Analytics

Learn and apply 25 Snowflake Semantic View modeling patterns with interactive tutorials and examples.

Master advanced SQL features, stored procedures, and warehouse optimization on Databricks.

Add AI tasks like classification, extraction, and summarization directly to SQL and PySpark pipelines.

Diagnose slow SQL queries and fix them with the right indexes and rewrites.

Enable C-suite agents to query each other, coordinate analysis, and prevent communication loops.

Generate SQL queries from plain English descriptions for BigQuery, PostgreSQL, MySQL, and more.

Extract web pages as clean, readable Markdown with clutter removed.

Look up CLI commands and documentation for managing skills.

Track Studio job metrics including compute hours, spend, failures, and cluster usage.

Add performance profiling to your Rust project with zero overhead when disabled.

Design database schemas visually with entity-relationship diagrams and Prisma format.

Design and optimize SQL, NoSQL, and vector databases with schemas, indexing, and compliance.

Design schemas, optimize queries, and choose the right database for your application.

Recover context from interrupted Claude sessions and continue work without replaying full history.

Build comprehensive literature search results with quality-ranked DOI lists and formatted references.

Import live database schemas and create semantic layers from snapshot files.

Query and manage MySQL or PostgreSQL databases on AWS Aurora with serverless scaling.

Query your KTX database to analyze data, find records, and explore metrics.

Map dbt models and sources into semantic layer overlays with column metadata.

Identify recurring SQL query patterns across database tables for analysis.

Convert SQL table usage data into typed evidence for schema projection.

Search your past AI coding sessions to find previous solutions and decisions.

Write declarative data visualization queries combining SQL with grammar of graphics principles.

Search, save, and index your local documents for quick semantic retrieval.

Create and manage database schema changes with Flyway naming conventions and versioning.

Query US congressional stock trades and politician investment activity with rich filters.

Generate Chen-model ER diagrams from SQL or DBML schemas with export options.

Run multi-turn AI analysis tasks with database and RAG context.

Fetch US economic data like CPI, GDP, unemployment, and Fed rates from the St. Louis Fed.

Optimize ClickHouse queries and design high-performance analytical databases.

Build and manage semantic layers that map databases to business metrics and dimensions.

Decide whether an AI agent should run code or reason in text for each task.

Query wallet balances, token portfolios, transactions, and NFTs on Solana with USD pricing.

Build and optimize Snowflake data pipelines, SQL queries, and AI-powered applications.

Write optimized Snowflake queries using QUALIFY, FLATTEN, and semi-structured data patterns.