docs: document behavior that changed in v2.4.0 (#2332) Update website/docs for behavior that differs between v2.3.2 and v2.4.0-rc.1: EXPLAIN options and new SQL functions, adaptive HTTP rate control, ORC and metadata-column listing pruning, connector pushdown, snapshot reader and writer behavior, cache invalidation, and MCP and model error handling.

feat(website): publish agent discovery documents for spiceai.org (#2319) * feat(website): publish agent discovery documents for spiceai.org Implement the isitagentready.com checks that apply to a static docs site: - Serve each page as Markdown to requests that prefer text/markdown (functions/_middleware.js, using the files the llms-txt plugin now writes) - Send RFC 8288 Link headers on the homepage - Publish an RFC 9727 API catalog and /openapi.json for the runtime HTTP API - Publish the spiceai/skills v2.3.2 skills with an Agent Skills Discovery index - Publish an ARD manifest at /.well-known/ard.json and ai-catalog.json - Register WebMCP tools (search_docs, get_page_markdown) - Declare Content Signals in robots.txt * fix(website): download the agent skills at a pinned commit, not a tag A tag can be moved to different content, and the index digests describe only the downloaded bytes. Pin skillsCommit to the v2.3.2 release commit and reject an archive of any other commit before publishing. * fix(website): use the standard ARD media types for skills A single SKILL.md is text/markdown; profile="urn:air:agent-skills" in the ARD conformance definitions, not application/agent-skills+md. Drop the llms.txt entry, whose plain text/markdown type ARD reads as a skill missing its profile. * fix(website): read search result URLs with get_page_markdown on any deployment search_docs returns canonical https://spiceai.org URLs, which get_page_markdown rejected on preview and local deployments. Read the same path from the current deployment instead. Also write the zero-width space regex as \u200b. * fix(website): serve openapi.json with its OpenAPI media type, skip Functions for favicons /openapi.json was served as application/json although the API catalog and Link headers advertise application/vnd.oai.openapi+json. Root favicon requests invoked the middleware; exclude them in _routes.json.

feat(website): publish agent discovery documents for spiceai.org (#2319) * feat(website): publish agent discovery documents for spiceai.org Implement the isitagentready.com checks that apply to a static docs site: - Serve each page as Markdown to requests that prefer text/markdown (functions/_middleware.js, using the files the llms-txt plugin now writes) - Send RFC 8288 Link headers on the homepage - Publish an RFC 9727 API catalog and /openapi.json for the runtime HTTP API - Publish the spiceai/skills v2.3.2 skills with an Agent Skills Discovery index - Publish an ARD manifest at /.well-known/ard.json and ai-catalog.json - Register WebMCP tools (search_docs, get_page_markdown) - Declare Content Signals in robots.txt * fix(website): download the agent skills at a pinned commit, not a tag A tag can be moved to different content, and the index digests describe only the downloaded bytes. Pin skillsCommit to the v2.3.2 release commit and reject an archive of any other commit before publishing. * fix(website): use the standard ARD media types for skills A single SKILL.md is text/markdown; profile="urn:air:agent-skills" in the ARD conformance definitions, not application/agent-skills+md. Drop the llms.txt entry, whose plain text/markdown type ARD reads as a skill missing its profile. * fix(website): read search result URLs with get_page_markdown on any deployment search_docs returns canonical https://spiceai.org URLs, which get_page_markdown rejected on preview and local deployments. Read the same path from the current deployment instead. Also write the zero-width space regex as \u200b. * fix(website): serve openapi.json with its OpenAPI media type, skip Functions for favicons /openapi.json was served as application/json although the API catalog and Link headers advertise application/vnd.oai.openapi+json. Root favicon requests invoked the middleware; exclude them in _routes.json.

Update openapi.json for spiceai/spiceai#12686 Adds POST /v1/datasets/{name}/cdc for pushing Debezium CDC changes directly into an accelerated dataset (from: cdc:…, refresh_mode: changes) without Kafka, plus the CdcIngestResponse schema.

docs: Sync the cookbook page and recipe links with spiceai/cookbook (#2318) * Sync the cookbook page with the current spiceai/cookbook recipes List all 122 current recipes (up from 79) and leave out evals, llm-judge, and websearch, which the cookbook marks deprecated in v2.0+. - Correct entries that pointed at the wrong recipe or described an old version: Results Caching linked the Caching Accelerator recipe, Nvidia NIM on Kubernetes linked the EC2 recipe, Hashed Partitioning now uses Cayenne, and Federated SQL Query no longer uses Dremio. - Add the missing recipes, including Cayenne, async queries, native PostgreSQL/MySQL/MongoDB CDC, DynamoDB Streams, HTTP, Redshift, ScyllaDB, SMB, the catalog connectors, full-text search, distributed query, and Spice as an MCP server. - Add Change Data Capture and Advanced Topics sections. Local Dataset Replication was tagged for no rendered section, so it never appeared. - Show guides in Sample Applications and Guides instead of Security. - Align Core Features with the cookbook's core scenarios and feature Cayenne as the data accelerator. - Label recipes that need Spice.ai Enterprise. - Remove forbidden words (enhance, leverage, utilize, robust) from section intros. * Fix broken and stale cookbook recipe references across doc versions Every version links to the recipes on cookbook trunk, so these corrections apply to each version that carries them. - Query Federation: replace the walkthrough with the current Federated SQL Query recipe, which joins NYC taxi trips in S3 with taxi zones in PostgreSQL. The old walkthrough logged in to a demo Dremio, ran 'spice add spiceai/fed-demo' (that Spicepod no longer exists on Spicerack), and ran 'cd demo' twice. The new steps and output come from a run of the recipe on Spice v2.3.2. - FAQ: the RAG recipe link (cookbook/tree/trunk/rag) never existed; link the RAG use-case page instead. - Use cases: fix duckdb/accelerator/README and federation/README links that were missing the .md extension. - PostgreSQL connector: link the connector recipe instead of the accelerator recipe, and fix 'configure Supabase a data connector'. - ODBC connector: the recipe now connects to MySQL with the MariaDB driver, not Postgres. - Glue catalog connector: its recipe configures the Glue Catalog Connector, not the Data Connector. - Release notes: fix three recipe links that pointed at moved or malformed paths. * Link docs pages to their cookbook recipes 49 cookbook recipes had no link from any docs page. Add a Cookbook section, or a bullet in an existing one, on the matching page in vNext and 2.3.x. Covered pages include CDC (PostgreSQL, MySQL, Aurora MySQL, MongoDB), the catalog connectors (DuckLake, MySQL, SQL Server, Unity Catalog, Databricks, Iceberg Hadoop, PostgreSQL CDC), acceleration (partitioning, snapshots, indexes, constraints, views, caching, cron refresh, dual-dataset registration), search, distributed query and async queries, MCP, LLM memory, text-to-SQL, the ai() function, models (OpenAI, DeepSeek, filesystem, xAI, NVIDIA NIM on Kubernetes), API keys, ADBC, JDBC, the SDKs, and Cloud Connect. The sidecar and microservice architecture partials, which every version shares, link their recipes too. Related updates: - The docs landing page lists Cayenne among the accelerators and links the Cayenne recipe. - The Cayenne Transactions intro also covers tables configured for durable write-back, matching the section's own requirements. - The FAQ says the cookbook has over 120 recipes, up from over 65.

feat(website): publish agent discovery documents for spiceai.org (#2319) * feat(website): publish agent discovery documents for spiceai.org Implement the isitagentready.com checks that apply to a static docs site: - Serve each page as Markdown to requests that prefer text/markdown (functions/_middleware.js, using the files the llms-txt plugin now writes) - Send RFC 8288 Link headers on the homepage - Publish an RFC 9727 API catalog and /openapi.json for the runtime HTTP API - Publish the spiceai/skills v2.3.2 skills with an Agent Skills Discovery index - Publish an ARD manifest at /.well-known/ard.json and ai-catalog.json - Register WebMCP tools (search_docs, get_page_markdown) - Declare Content Signals in robots.txt * fix(website): download the agent skills at a pinned commit, not a tag A tag can be moved to different content, and the index digests describe only the downloaded bytes. Pin skillsCommit to the v2.3.2 release commit and reject an archive of any other commit before publishing. * fix(website): use the standard ARD media types for skills A single SKILL.md is text/markdown; profile="urn:air:agent-skills" in the ARD conformance definitions, not application/agent-skills+md. Drop the llms.txt entry, whose plain text/markdown type ARD reads as a skill missing its profile. * fix(website): read search result URLs with get_page_markdown on any deployment search_docs returns canonical https://spiceai.org URLs, which get_page_markdown rejected on preview and local deployments. Read the same path from the current deployment instead. Also write the zero-width space regex as \u200b. * fix(website): serve openapi.json with its OpenAPI media type, skip Functions for favicons /openapi.json was served as application/json although the API catalog and Link headers advertise application/vnd.oai.openapi+json. Root favicon requests invoked the middleware; exclude them in _routes.json.

feat(website): publish agent discovery documents for spiceai.org (#2319) * feat(website): publish agent discovery documents for spiceai.org Implement the isitagentready.com checks that apply to a static docs site: - Serve each page as Markdown to requests that prefer text/markdown (functions/_middleware.js, using the files the llms-txt plugin now writes) - Send RFC 8288 Link headers on the homepage - Publish an RFC 9727 API catalog and /openapi.json for the runtime HTTP API - Publish the spiceai/skills v2.3.2 skills with an Agent Skills Discovery index - Publish an ARD manifest at /.well-known/ard.json and ai-catalog.json - Register WebMCP tools (search_docs, get_page_markdown) - Declare Content Signals in robots.txt * fix(website): download the agent skills at a pinned commit, not a tag A tag can be moved to different content, and the index digests describe only the downloaded bytes. Pin skillsCommit to the v2.3.2 release commit and reject an archive of any other commit before publishing. * fix(website): use the standard ARD media types for skills A single SKILL.md is text/markdown; profile="urn:air:agent-skills" in the ARD conformance definitions, not application/agent-skills+md. Drop the llms.txt entry, whose plain text/markdown type ARD reads as a skill missing its profile. * fix(website): read search result URLs with get_page_markdown on any deployment search_docs returns canonical https://spiceai.org URLs, which get_page_markdown rejected on preview and local deployments. Read the same path from the current deployment instead. Also write the zero-width space regex as \u200b. * fix(website): serve openapi.json with its OpenAPI media type, skip Functions for favicons /openapi.json was served as application/json although the API catalog and Link headers advertise application/vnd.oai.openapi+json. Root favicon requests invoked the middleware; exclude them in _routes.json.

docs(datasets): a time_format mismatch fails the dataset, and iso8601 on a timestamp or date column is ignored with a warning (#2325) * docs(datasets): a time_format mismatch fails the dataset, and iso8601 on a timestamp or date column is ignored with a warning (spiceai/spiceai#14777) * docs(datasets): a string time_column needs time_format iso8601 (spiceai/spiceai#14777)

docs: publish v2.3.0 documentation and release notes (#2192) * Add versioned docs for v2.3 * docs: publish v2.3.0 release notes and announcement * docs: remove the temporary local build configuration * docs: limit the LLM bundle to the latest released version --------- Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com> Co-authored-by: Phillip LeBlanc <879445+phillipleblanc@users.noreply.github.com>

Add blog (#735) * Add blog * Update * Update authors.yml * Update v1.0-rc.4.md * Fixes * Update v0.20-beta.md * Update v0.19.4-beta.md * Update v0.17.2-beta.md * Update v0.17.1-beta.md * Update v0.17-beta.md * Update v0.13.3-alpha.md * Update v0.12.1-alpha.md * Update v0.10-alpha.md * Update v0.7-alpha.md * Update v0.6-alpha.md * Update v0.5.1-alpha.md * Update v0.5-alpha.md * Update v0.4-alpha.md * Update v0.3-alpha.md * Update authors, update releases (#736) * Update authors.yml * Update v0.19-beta.md * Update v1.0-rc.2.md * Add website * add jeadie author, add to releases * Fixes * Update packages * Fixes for react * Fixes * Merge * Update names * Use hosted generator * Tweak * fix scoped tailwind styles * Fix images * use scpoed preflight.css, adjust home page styles * Update links * Update inline HTML to Markdown * add evgenii to authors * fix expressions * fix static links * fix linnks * fix url docs links * fix blog links * prefix docs links with /docs * fix fonts and tweak styles * apply fonts * add sgrebnov to authors * Fix broken links --------- Co-authored-by: Phillip LeBlanc <phillip@spiceai.io> Co-authored-by: peasee <98815791+peasee@users.noreply.github.com> Co-authored-by: jeadie <jack@spice.ai> Co-authored-by: Evgenii Khramkov <evgenii@spice.ai> Co-authored-by: Sergei Grebnov <sergei.grebnov@gmail.com>

Check in versioned docs and remove generate-versions script (#1386) * Check in versioned docs and remove generate-versions script Transition from per-branch versioning to all versions checked in. Generated versioned docs from release branches 1.5 through 1.11. Removed generate-versions.sh and updated .gitignore. * Remove generate-versions script from build workflow Versioned docs are now checked in directly. Remove the script invocation from package.json build, drop the fetch-depth: 0 from CI (no longer needed), and update README to reflect the new process.

Add blog (#735) * Add blog * Update * Update authors.yml * Update v1.0-rc.4.md * Fixes * Update v0.20-beta.md * Update v0.19.4-beta.md * Update v0.17.2-beta.md * Update v0.17.1-beta.md * Update v0.17-beta.md * Update v0.13.3-alpha.md * Update v0.12.1-alpha.md * Update v0.10-alpha.md * Update v0.7-alpha.md * Update v0.6-alpha.md * Update v0.5.1-alpha.md * Update v0.5-alpha.md * Update v0.4-alpha.md * Update v0.3-alpha.md * Update authors, update releases (#736) * Update authors.yml * Update v0.19-beta.md * Update v1.0-rc.2.md * Add website * add jeadie author, add to releases * Fixes * Update packages * Fixes for react * Fixes * Merge * Update names * Use hosted generator * Tweak * fix scoped tailwind styles * Fix images * use scpoed preflight.css, adjust home page styles * Update links * Update inline HTML to Markdown * add evgenii to authors * fix expressions * fix static links * fix linnks * fix url docs links * fix blog links * prefix docs links with /docs * fix fonts and tweak styles * apply fonts * add sgrebnov to authors * Fix broken links --------- Co-authored-by: Phillip LeBlanc <phillip@spiceai.io> Co-authored-by: peasee <98815791+peasee@users.noreply.github.com> Co-authored-by: jeadie <jack@spice.ai> Co-authored-by: Evgenii Khramkov <evgenii@spice.ai> Co-authored-by: Sergei Grebnov <sergei.grebnov@gmail.com>

Add create-release script + workflow (#1392)

feat(website): publish agent discovery documents for spiceai.org (#2319) * feat(website): publish agent discovery documents for spiceai.org Implement the isitagentready.com checks that apply to a static docs site: - Serve each page as Markdown to requests that prefer text/markdown (functions/_middleware.js, using the files the llms-txt plugin now writes) - Send RFC 8288 Link headers on the homepage - Publish an RFC 9727 API catalog and /openapi.json for the runtime HTTP API - Publish the spiceai/skills v2.3.2 skills with an Agent Skills Discovery index - Publish an ARD manifest at /.well-known/ard.json and ai-catalog.json - Register WebMCP tools (search_docs, get_page_markdown) - Declare Content Signals in robots.txt * fix(website): download the agent skills at a pinned commit, not a tag A tag can be moved to different content, and the index digests describe only the downloaded bytes. Pin skillsCommit to the v2.3.2 release commit and reject an archive of any other commit before publishing. * fix(website): use the standard ARD media types for skills A single SKILL.md is text/markdown; profile="urn:air:agent-skills" in the ARD conformance definitions, not application/agent-skills+md. Drop the llms.txt entry, whose plain text/markdown type ARD reads as a skill missing its profile. * fix(website): read search result URLs with get_page_markdown on any deployment search_docs returns canonical https://spiceai.org URLs, which get_page_markdown rejected on preview and local deployments. Read the same path from the current deployment instead. Also write the zero-width space regex as \u200b. * fix(website): serve openapi.json with its OpenAPI media type, skip Functions for favicons /openapi.json was served as application/json although the API catalog and Link headers advertise application/vnd.oai.openapi+json. Root favicon requests invoked the middleware; exclude them in _routes.json.

build(deps): bump the npm_and_yarn group across 1 directory with 3 updates (#2315) Bumps the npm_and_yarn group with 3 updates in the /website directory: [qs](https://github.com/ljharb/qs), [shell-quote](https://github.com/ljharb/shell-quote) and [source-map-js](https://github.com/7rulnik/source-map-js). Updates `qs` from 6.15.3 to 6.16.0 - [Changelog](https://github.com/ljharb/qs/blob/main/CHANGELOG.md) - [Commits](https://github.com/ljharb/qs/compare/v6.15.3...v6.16.0) Updates `shell-quote` from 1.10.0 to 1.12.0 - [Changelog](https://github.com/ljharb/shell-quote/blob/main/CHANGELOG.md) - [Commits](https://github.com/ljharb/shell-quote/compare/v1.10.0...v1.12.0) Updates `source-map-js` from 1.2.1 to 1.2.2 - [Release notes](https://github.com/7rulnik/source-map-js/releases) - [Changelog](https://github.com/7rulnik/source-map-js/blob/main/CHANGELOG.md) - [Commits](https://github.com/7rulnik/source-map-js/compare/v1.2.1...v1.2.2) --- updated-dependencies: - dependency-name: qs dependency-version: 6.16.0 dependency-type: indirect dependency-group: npm_and_yarn - dependency-name: shell-quote dependency-version: 1.12.0 dependency-type: indirect dependency-group: npm_and_yarn - dependency-name: source-map-js dependency-version: 1.2.2 dependency-type: indirect dependency-group: npm_and_yarn ... Signed-off-by: dependabot[bot] <support@github.com> Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> Co-authored-by: Luke Kim <80174+lukekim@users.noreply.github.com>

build(deps): bump sharp Bumps the npm_and_yarn group with 1 update in the /website directory: [sharp](https://github.com/lovell/sharp). Updates `sharp` from 0.35.2 to 0.35.4 - [Release notes](https://github.com/lovell/sharp/releases) - [Commits](https://github.com/lovell/sharp/compare/v0.35.2...v0.35.4) --- updated-dependencies: - dependency-name: sharp dependency-version: 0.35.4 dependency-type: indirect dependency-group: npm_and_yarn ... Signed-off-by: dependabot[bot] <support@github.com>

feat(website): publish agent discovery documents for spiceai.org (#2319) * feat(website): publish agent discovery documents for spiceai.org Implement the isitagentready.com checks that apply to a static docs site: - Serve each page as Markdown to requests that prefer text/markdown (functions/_middleware.js, using the files the llms-txt plugin now writes) - Send RFC 8288 Link headers on the homepage - Publish an RFC 9727 API catalog and /openapi.json for the runtime HTTP API - Publish the spiceai/skills v2.3.2 skills with an Agent Skills Discovery index - Publish an ARD manifest at /.well-known/ard.json and ai-catalog.json - Register WebMCP tools (search_docs, get_page_markdown) - Declare Content Signals in robots.txt * fix(website): download the agent skills at a pinned commit, not a tag A tag can be moved to different content, and the index digests describe only the downloaded bytes. Pin skillsCommit to the v2.3.2 release commit and reject an archive of any other commit before publishing. * fix(website): use the standard ARD media types for skills A single SKILL.md is text/markdown; profile="urn:air:agent-skills" in the ARD conformance definitions, not application/agent-skills+md. Drop the llms.txt entry, whose plain text/markdown type ARD reads as a skill missing its profile. * fix(website): read search result URLs with get_page_markdown on any deployment search_docs returns canonical https://spiceai.org URLs, which get_page_markdown rejected on preview and local deployments. Read the same path from the current deployment instead. Also write the zero-width space regex as \u200b. * fix(website): serve openapi.json with its OpenAPI media type, skip Functions for favicons /openapi.json was served as application/json although the API catalog and Link headers advertise application/vnd.oai.openapi+json. Root favicon requests invoked the middleware; exclude them in _routes.json.

Add blog (#735) * Add blog * Update * Update authors.yml * Update v1.0-rc.4.md * Fixes * Update v0.20-beta.md * Update v0.19.4-beta.md * Update v0.17.2-beta.md * Update v0.17.1-beta.md * Update v0.17-beta.md * Update v0.13.3-alpha.md * Update v0.12.1-alpha.md * Update v0.10-alpha.md * Update v0.7-alpha.md * Update v0.6-alpha.md * Update v0.5.1-alpha.md * Update v0.5-alpha.md * Update v0.4-alpha.md * Update v0.3-alpha.md * Update authors, update releases (#736) * Update authors.yml * Update v0.19-beta.md * Update v1.0-rc.2.md * Add website * add jeadie author, add to releases * Fixes * Update packages * Fixes for react * Fixes * Merge * Update names * Use hosted generator * Tweak * fix scoped tailwind styles * Fix images * use scpoed preflight.css, adjust home page styles * Update links * Update inline HTML to Markdown * add evgenii to authors * fix expressions * fix static links * fix linnks * fix url docs links * fix blog links * prefix docs links with /docs * fix fonts and tweak styles * apply fonts * add sgrebnov to authors * Fix broken links --------- Co-authored-by: Phillip LeBlanc <phillip@spiceai.io> Co-authored-by: peasee <98815791+peasee@users.noreply.github.com> Co-authored-by: jeadie <jack@spice.ai> Co-authored-by: Evgenii Khramkov <evgenii@spice.ai> Co-authored-by: Sergei Grebnov <sergei.grebnov@gmail.com>

Try Open Sans font (#784)

Add blog (#735) * Add blog * Update * Update authors.yml * Update v1.0-rc.4.md * Fixes * Update v0.20-beta.md * Update v0.19.4-beta.md * Update v0.17.2-beta.md * Update v0.17.1-beta.md * Update v0.17-beta.md * Update v0.13.3-alpha.md * Update v0.12.1-alpha.md * Update v0.10-alpha.md * Update v0.7-alpha.md * Update v0.6-alpha.md * Update v0.5.1-alpha.md * Update v0.5-alpha.md * Update v0.4-alpha.md * Update v0.3-alpha.md * Update authors, update releases (#736) * Update authors.yml * Update v0.19-beta.md * Update v1.0-rc.2.md * Add website * add jeadie author, add to releases * Fixes * Update packages * Fixes for react * Fixes * Merge * Update names * Use hosted generator * Tweak * fix scoped tailwind styles * Fix images * use scpoed preflight.css, adjust home page styles * Update links * Update inline HTML to Markdown * add evgenii to authors * fix expressions * fix static links * fix linnks * fix url docs links * fix blog links * prefix docs links with /docs * fix fonts and tweak styles * apply fonts * add sgrebnov to authors * Fix broken links --------- Co-authored-by: Phillip LeBlanc <phillip@spiceai.io> Co-authored-by: peasee <98815791+peasee@users.noreply.github.com> Co-authored-by: jeadie <jack@spice.ai> Co-authored-by: Evgenii Khramkov <evgenii@spice.ai> Co-authored-by: Sergei Grebnov <sergei.grebnov@gmail.com>

docs: publish v2.3.0 documentation and release notes (#2192) * Add versioned docs for v2.3 * docs: publish v2.3.0 release notes and announcement * docs: remove the temporary local build configuration * docs: limit the LLM bundle to the latest released version --------- Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com> Co-authored-by: Phillip LeBlanc <879445+phillipleblanc@users.noreply.github.com>