Text-to-SQL with Spice (Bring Your Own Model)

Generate accurate SQL for Spice.ai using your own LLM. This skill provides the schema introspection workflow, type reference, SQL dialect rules, and prompt template needed to produce correct queries on the first attempt — avoiding trial-and-error.

How It Works

1. Read spicepod.yaml to know which datasets, models, embeddings, and features are configured
2. Introspect the Spice catalog to discover tables, columns, and types
3. Build a prompt containing schema, type info, and dialect rules
4. Send the prompt to your LLM to generate SQL
5. Execute the SQL — on failure, feed the error back and retry

Step 0 — Read the Spicepod Configuration

Before generating SQL, read the application's spicepod.yaml to understand what is available. This tells you: