Skip to content

algoprog/sqlite

v1.0.1MIT

Tools to look inside SQLite databases, query them safely, change them in one go, and move data in and out of CSV files.

SQLite databases

Gives every agent six tools for SQLite files (.db, .sqlite, .sqlite3):

ToolWhat it does
sqlite_tablesThe tables and views, with each table's row count
sqlite_schemaHow a table is defined: columns, keys, indexes, foreign keys
sqlite_queryRuns a query that only reads; the file is opened read-only
sqlite_executeChanges data or tables, in one transaction (all or nothing)
sqlite_import_csvLoads a CSV file into a table
sqlite_export_csvWrites a query's rows to a CSV file

It needs only Python 3, with nothing to install. The skill sqlite-databases tells agents how to work with a database carefully: look first, back up before changing, and check the result.