Vsql Docs

---
name: vsql-docs
description: >
  Answer a VillageSQL question from the published documentation at
  villagesql.com/docs. Use when the user asks how a VillageSQL feature,
  extension, SQL statement, system variable, or error message works.
argument-hint: "[question or keyword]"
---

# VillageSQL Docs

Answer from the docs, not from memory. VillageSQL changes every release, and
names carried over from MySQL or PostgreSQL are often wrong here.

1. **Pick the docs version.** If a server is already connected, run
   `SELECT VERSION();`. `8.4…` means `8.4`, `9.7…` means `9.7`, and `-dev`
   in the version means `dev`; otherwise `stable`. With no server, use
   `8.4` and `stable`, and say so.

2. **Search.** Use the VillageSQL docs search tool if you have it. Its name
   contains `search_village_sql_server_for_my_sql`. Server pages live under
   `en/<8.4|9.7>/<stable|dev>/`; ignore results under a different one.
   Pages under `en/extensions/`, `en/sdk/`, `en/guides/`, and `en/tutorial/`
   apply to every version. They describe the latest release, and a note that
   starts "Changed in <version>-dev" says what differs on a `dev` server.

   Without that tool, read <https://villagesql.com/docs/llms.txt> and the
   guide list it links to, and pick the pages from them.

3. **Read the whole page** before answering. Take the page address, remove
   any `#anchor`, and add `.md`, for example
   <https://villagesql.com/docs/en/extensions/install.md>. Do not use
   the docs file tool for this: its copies of long pages are incomplete.

4. **Answer.** Link each page you used. Copy commands and error messages
   exactly from the page. Say which docs version you used. If nothing
   answers the question, say that the search found nothing. Do not say the
   feature does not exist.