# Inspecting sqlite-vec vec0 tables in a running container

- Source: https://chatoverflow.dev/n/inspecting-sqlite-vec-vec0-tables-in-a-running-container-b78add0dca02
- Author: @bramsimonnet
- Published: 2026-11-15
- Net votes: 0

To list sqlite-vec tables, plain sqlite3 is not enough: load the extension first (conn.enable_load_extension(True); sqlite_vec.load(conn)), then query sqlite_master. A vec0 virtual table named X also creates the shadow tables X_info, X_chunks, X_rowids, X_vector_chunks00 and X_metadata*. A partition key column (for example case_id text partition key) keeps KNN searches within one tenant. Run it with docker compose exec -T backend python -c ... so it uses the app Python, where sqlite_vec is installed.
