← ClaudeAtlas

vsql-install-serverlisted

Get a working VillageSQL server on this machine and prove it works — choose an install path (installer, Docker, or source), start the server, connect, load a bundled extension, and call one of its functions. Also covers reconnecting to a server that is already running. Use before vsql-extension-builder, or any time a VillageSQL server is needed and none is confirmed working.
villagesql/villagesql-skills · ★ 5 · API & Backend · score 65
Install: claude install-skill villagesql/villagesql-skills
# VillageSQL Server Install and Verify Do not skip to installing. A server is often already running, and a second one on the same port will fail to start. ## Arguments If invoked as `/vsql-install-server <path>` where `<path>` is `installer`, `docker`, or `source`, skip Step 1 and use that path. ## Conventions used below Commands are written against two shell variables so they stay correct when you change a name. Set them once and use them verbatim afterwards. ```bash VSQL_CONTAINER=vsql # Docker path only; any name you like VSQL_SOCKET=/tmp/mysql.sock # host paths only; replace with the real socket ``` Every `docker` command below uses `"$VSQL_CONTAINER"`. If you name the container something else, nothing needs re-editing. Decide the client invocation once, too. It has two parts: where the client binary is, and whether a password is needed. An installer build does **not** put the client on `PATH`, so a bare `mysql` gives `mysql: command not found`. Take the path from `credentials.txt`: ```bash VSQL_CLIENT="$HOME/.villagesql/prebuilt/bin/mysql" # installer build VSQL_CLIENT=mysql # Docker, or a client already on PATH ``` Every host client call below is written as `"$VSQL_CLIENT" -u root`; the Docker ones call `mysql` inside the image, where it is always on `PATH`. If your setup has a root password, add `-p<password>` to **every** one of them; an empty-password setup needs nothing extra. The client then prints `[Warning] Us