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.

Find new job postings matching your profile across LinkedIn and job boards.

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

Read and extract data from files in multiple formats.

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

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.

Look up CLI commands and documentation for managing skills.

Debug agent tool-calling issues through guided diagnosis and schema repair.

Get concrete ISO date ranges for the rolling 7-day window ending today.

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

Avoid common GA4 API pitfalls that return misleading data instead of errors.

Design spatial database tables with PostGIS geometry types, indexing, and performance optimization.

Migrate PostgreSQL tables to TimescaleDB hypertables with configuration and validation.

Set up vector similarity search in PostgreSQL for AI embeddings and semantic retrieval.

Combine keyword and semantic search in PostgreSQL using BM25 and vectors.

Search code by meaning and trace function calls in your codebase.

Identify pitfalls in Google Search Console API queries to avoid silent errors.

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.

Review pull requests for MariaDB Operator against project conventions and best practices.

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.

Start or restart a local Temps development server with isolated ports per branch.

Analyze Java project structure, packages, layers, and dependency boundaries.

Control and inspect live browser panels within Horizon workspace.

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

Manage and monitor the AWS-hosted Pilot daemon with status, logs, and operational commands.

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

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.

Evaluate math expressions and convert between units.

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

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

Execute Stata scripts, install packages, and analyze data structures.

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.