# DeltaForge Documentation

> Complete SQL, CLI, GUI, and ODBC reference for DeltaForge: a native PostgreSQL-compatible SQL engine for Delta Lake and Apache Iceberg. Every command, function, operator, keyword, data type, table property, demo, graph algorithm, spatial function, PL/pgSQL construct, pipeline configuration option, data source, CLI flag, and GUI feature is documented here, both as static HTML for human readers and as JSON for machine consumption.

This file is the AI-agent index for docs.deltaforge.org. Every link is a canonical https URL. Static HTML pages are listed by section; the per-item JSON corpus is at the predictable URLs in the Machine-readable section. Use the search index to resolve any name to an id, then fetch either the HTML (for human-formatted content) or the JSON (for structured fields).

## Complete reference index

- [All documented entries (HTML hub)](https://docs.deltaforge.org/sitemap.html): One page listing every documented entry across all sections as a real anchor tag. Recommended starting point for link-graph crawlers.

## Section indexes (HTML)

- [CLI Reference](https://docs.deltaforge.org/cli/): 90 entries. Reference index linking every cli reference entry, grouped by category.
- [SQL Commands](https://docs.deltaforge.org/commands/): 207 entries. Reference index linking every sql commands entry, grouped by category.
- [Data Sources](https://docs.deltaforge.org/data-sources/): 23 entries. Reference index linking every data sources entry, grouped by category.
- [Demos](https://docs.deltaforge.org/demos/): 68 entries. Reference index linking every demos entry, grouped by category.
- [Built-in Functions](https://docs.deltaforge.org/functions/): 415 entries. Reference index linking every built-in functions entry, grouped by category.
- [Graph Analytics](https://docs.deltaforge.org/graph-analytics/): 48 entries. Reference index linking every graph analytics entry, grouped by category.
- [GUI Reference](https://docs.deltaforge.org/gui/): 31 entries. Reference index linking every gui reference entry, grouped by category.
- [ODBC Driver](https://docs.deltaforge.org/odbc/): 30 entries. Reference index linking every odbc driver entry, grouped by category.
- [Pipeline Configuration](https://docs.deltaforge.org/pipeline-config/): 40 entries. Reference index linking every pipeline configuration entry, grouped by category.
- [PL/pgSQL](https://docs.deltaforge.org/plpgsql/): 25 entries. Reference index linking every pl/pgsql entry, grouped by category.
- [Spatial Functions](https://docs.deltaforge.org/spatial/): 40 entries. Reference index linking every spatial functions entry, grouped by category.

## Consolidated references (HTML)

- [Data Types](https://docs.deltaforge.org/data-types.html): All 58 data types on a single reference page with syntax and semantics.
- [SQL Keywords](https://docs.deltaforge.org/keywords.html): All 474 sql keywords on a single reference page with syntax and semantics.
- [Operators](https://docs.deltaforge.org/operators.html): All 40 operators on a single reference page with syntax and semantics.
- [Table Properties](https://docs.deltaforge.org/table-properties.html): All 105 table properties on a single reference page with syntax and semantics.

## Machine-readable JSON

Each documented item is also available as JSON at a predictable URL. Fetch directly when you need structured fields rather than rendered HTML.

- [Section navigation](https://docs.deltaforge.org/data/nav.json): All sections with their categories and entry counts.
- [Search index](https://docs.deltaforge.org/data/search.json): Single JSON array with id, name, section, category, summary for every entry. Use to resolve a name to an id.
- [Per-item example: SELECT](https://docs.deltaforge.org/data/doc/SELECT.json): Each item lives at `https://docs.deltaforge.org/data/doc/<ID>.json`. Fields: id, name, category, summary, syntax, parameters, examples, description, see_also.

## Marketing site

- [DeltaForge home](https://deltaforge.org/): Top-level positioning, capabilities, pricing, install.
- [Marketing llms.txt](https://deltaforge.org/llms.txt): The companion index for the marketing site.
- [Marketing sitemap](https://deltaforge.org/sitemap.xml): All marketing HTML pages.

## Last Updated

2026-06-02