sudo lsof .villagesql/data/ibdata1
sudo fuser -v .villagesql/data/ibdata1
INODE=$(stat -c %i .villagesql/data/ibdata1)
grep ":$INODE " /proc/locks
ps -ef | grep [m]ysqld
systemctl list-units --all | grep -Ei 'mysql|villagesql'
.villagesql/prebuilt/bin/mysqld --verbose --help | grep -E '^datadir'
| ``` | |
| $ uname -a | |
| Linux spark-a414 7.0.0-1019-nvidia #19~24.04.2-Ubuntu SMP PREEMPT_DYNAMIC Sun Sep 6 18:35:11 UTC 2 aarch64 aarch64 aarch64 GNU/Linux | |
| $ cat /etc/os-release | |
| PRETTY_NAME="Ubuntu 24.04.5 LTS" | |
| NAME="Ubuntu" | |
| VERSION_ID="24.04" | |
| VERSION="24.04.5 LTS (Noble Numbat)" | |
| VERSION_CODENAME=noble |
Example files and the full mysql transcript for VillageSQL vsql_duckdb tests
(8.4.11-villagesql-0.0.7-dev).
GitHub gists are flat (no directories). Binary Hive partitions are included both as flat files and inside
examples.tar.gz(unpack to restoreregion=*/).
Generated: 2026-09-20 09:42 UTC
- Source SQL: attached
*.sql(VillageSQL / vsql-vector example: 1024-dim document similarity search) - Instance: nightly socket
/workspace/mysql-data/mysql.sock - Client:
/workspace/build/villagesql/bin/mysql -uroot --table --raw --force --show-warnings - Wrapper added before the script (script itself had no
USE):
| #!/usr/bin/env bash | |
| # | |
| # check-pq-ssh.sh | |
| # Check whether this machine negotiates post-quantum SSH key exchange | |
| # with GitHub, and whether a macOS crypto policy is overriding defaults. | |
| # | |
| # Companion script for: | |
| # https://ronaldbradford.com/blog/ (post-quantum SSH investigation) | |
| # | |
| # Usage: |
| #cloud-config | |
| # MySQL 9.7 LTS install for CentOS Stream 9 (works on aarch64/ARM64). | |
| # | |
| # Notes: | |
| # - The repo URL path is mysql-9.7-community (NOT mysql-9.7-lts-community); | |
| # only the repo *id* carries the -lts- label. | |
| # - MySQL's published GPG key file still shows expired (2025-10-22) even | |
| # though the key was re-extended, and the RPM-GPG-KEY-mysql-2025 URL is | |
| # empty. So gpgcheck is disabled here to keep an unattended boot from | |
| # failing. Re-enable once MySQL refreshes the published key file. |
See the blog Using GenAI directly in the database. A practical example using MySQL 8.0 for how we use a VillageSQL replica with the vsql-ai extension to summarize your support ticket data.
generate mermaid markdown for these tables.
erDiagramOn a different system with claude context, installed SDK and built skills.
It eventually got to that answer, but it should be more direct.
https://github.com/villagesql/villagesql-server/releases
FWIW, neither https://github.com/villagesql/villagesql-skills or https://github.com/villagesql/villagesql-skills/tree/main/skills/vsql-extension-builder spell it our as a pre-requisite.
Regarding your other question — can the extension builder skill work with just the prebuilt binary? Yes, the vsql-extension-builder skill only needs the VillageSQL SDK (headers + cmake modules) to build, and
| #cloud-config | |
| # Debian/Ubuntu demo VM for dbdeployer + PostgreSQL + ProxySQL | |
| packages: | |
| - libncurses6 | |
| - libaio-dev | |
| - libnuma1 | |
| - liburing2 | |
| - libdigest-sha-perl | |
| - postgresql-common |
| #!/usr/bin/bash | |
| [[ -n ${TRACE:-} ]] && set -x | |
| # DBDeployer - The MySQL Sandbox | |
| # Copyright (C) 2006-2020 Giuseppe Maxia | |
| # Creator: Ronald Bradford | |
| # | |
| # Licensed under the Apache License, Version 2.0 (the "License"); | |
| # you may not use this file except in compliance with the License. | |
| # You may obtain a copy of the License at |