{{- /* Home page template - generates SKILL.md for Claude */ -}}
---
name: materialize-docs
description: Materialize documentation for SQL syntax, data ingestion, concepts, and best practices. Use when users ask about Materialize queries, sources, sinks, views, or clusters.
---
# Materialize Documentation
This skill provides comprehensive documentation for Materialize, a streaming database for real-time analytics.
## How to Use This Skill
When a user asks about Materialize:
1. **For SQL syntax/commands**: Read files in the `sql/` directory
2. **For core concepts**: Read files in the `concepts/` directory
3. **For data ingestion**: Read files in the `ingest-data/` directory
4. **For transformations**: Read files in the `transform-data/` directory
## Documentation Sections
{{- range .Site.Sections }}
{{- $sectionName := .Section }}
{{- if not (in (slice "releases" "self-managed" "about" "get-started") $sectionName) }}
### {{ .Title }}
{{- with .Description }}
{{ . }}
{{- end }}
{{ range .Pages | first 10 }}
- **{{ .Title }}**: `{{ strings.TrimPrefix "/" .RelPermalink }}`
{{- end }}
{{- if gt (len .Pages) 10 }}
- _(and {{ sub (len .Pages) 10 }} more files in this section)_
{{- end }}
{{- end }}
{{- end }}
## Quick Reference
### Common SQL Commands
| Command | Description |
|---------|-------------|
| `CREATE SOURCE` | Connect to external data sources (Kafka, PostgreSQL, MySQL) |
| `CREATE MATERIALIZED VIEW` | Create incrementally maintained views |
| `CREATE INDEX` | Create indexes on views for faster queries |
| `CREATE SINK` | Export data to external systems |
| `SELECT` | Query data from sources, views, and tables |
### Key Concepts
- **Sources**: Connections to external data systems that stream data into Materialize
- **Materialized Views**: Views that are incrementally maintained as source data changes
- **Indexes**: Arrangements of data in memory for fast point lookups
- **Clusters**: Isolated compute resources for running dataflows
- **Sinks**: Connections that export data from Materialize to external systems
