The Vault

Data & Analytics

471 assets.

prompt

segmentation plan Variations

Produces several distinct, ready-to-use variations of segmentation plan.

—0+
prompt

Slow Query Optimization

Speed up a slow database query.

—0+
knowledge pack

Snowflake Cost Optimization Pack

Warehouse sizing, auto-suspend, clustering, query cost reduction tactics.

—0+
mcp server

Snowflake MCP

Snowflake Labs MCP server — run SQL, manage objects, and use Cortex AI on your Snowflake data.

—0+
prompt

Spreadsheet Automation Helper

Automate a repetitive spreadsheet task with a script.

—0+
prompt

Spreadsheet Dashboard Build

Build a clean live dashboard inside a spreadsheet.

—0+
prompt

Spreadsheet Formula Helper

Writes and explains a spreadsheet formula for your task.

—0+
prompt

Spreadsheet Model Audit

Find the errors hiding in a spreadsheet model.

—0+
prompt

SQL from a Question

Turn a plain question into a SQL query.

AI Khazna0+
knowledge pack

SQL Fundamentals Knowledge Pack

SELECT, JOIN, GROUP BY, subqueries, window functions — with worked examples.

—0+
prompt

SQL Performance Optimizer

Analyze slow SQL queries to identify bottlenecks (missing indexes, poor joins, large scans) and provide optimization rec…

AI Khazna0+
prompt

SQL Query Explainer

Turn a complex SQL query into a clear, step-by-step plain-language explanation for any reader.

—0+
prompt

SQL Query Explainer & Optimizer

Break down complex SQL logic, explain query performance issues, and suggest optimization strategies.

AI Khazna0+
prompt

SQL Query Explainer and Optimizer

Explain what a SQL query does in plain language and suggest safe performance optimizations.

AI Khazna0+
prompt

SQL Query from Business Question

Convert a business question into a production-ready SQL query with optimized joins, filters, and aggregations.

AI Khazna0+
agent template

SQL Query Generator Agent

Natural language to SQL with schema awareness — joins, CTEs, window functions.

—0+
prompt

SQL Query Optimizer

Analyze query performance bottlenecks and recommend indexing, partitioning, or join reordering strategies.

AI Khazna0+
agent template

SQL Query Optimizer Agent

Analyzes slow queries — index suggestions, rewrite, explain-plan reading.

—0+
prompt

SQL Query Writer

Write and explain a SQL query from a plain-language request.

—0+
workflow

SQL Schema Documentation Generator

Documents tables, columns, relationships, and generates an ER diagram.

—0+
prompt

SQL to Business Question Converter

Reverse-engineer a business question and assumptions from an existing {{sql_query}}.

AI Khazna0+
prompt

SQL Window Function Helper

Write tricky SQL window functions with a clear explanation.

—0+
prompt

Statistical Significance Check

Decide whether a result is real or just noise.

—0+
prompt

Statistical Significance Test Selector

Recommend appropriate statistical tests based on data distribution, sample size, and research question to validate exper…

AI Khazna0+