Function createSqlite3Command

src/agents/bash-sqlite-agent.ts:40–130

()

// Custom sqlite3 command using better-sqlite3 (bypasses broken sql.js ESM bundling in just-bash)
function createSqlite3Command() {
  return defineCommand('sqlite3', async (args) => {
    let showHeader = false;
    let separator = '|';
    const filteredArgs: string[] = [];

    for (let i = 0; i < args.length; i++) {
      const arg = args[i];
      if (arg === '-header') {
        showHeader = true;
      } else if (arg === '-separator' && i + 1 < args.length) {
        separator = args[++i];
      } else if (arg === '-csv') {
        separator = ',';
        showHeader = true;
      } else if (arg === '-json') {
        separator = 'json';
      } else if (!arg.startsWith('-')) {
        filteredArgs.push(arg);
      }
    }

    const [dbPath, ...sqlParts] = filteredArgs;
    const sql = sqlParts.join(' ');

    if (!dbPath) {
      return {
        stdout: '',
        stderr:
          'Usage: sqlite3 [OPTIONS] DATABASE [SQL]\nOptions: -header, -separator SEP, -csv, -json',
        exitCode: 1,
      };
    }

    if (!sql) {
      return { stdout: '', stderr: 'Error: no SQL statement provided', exitCode: 1 };
    }

    const actualPath = dbPath.startsWith('/')
      ? join(DATA_DIR, dbPath.slice(1))
      : join(DATA_DIR, dbPath);

    try {
      const require = createRequire(join(process.cwd(), 'package.json'));
      const Database = require('better-sqlite3');
      const db = new Database(actualPath, { readonly: true });

      try {
        const stmt = db.prepare(sql);
        const results = stmt.all();

        if (results.length === 0) {
          return { stdout: '', stderr: '', exitCode: 0 };
        }

        let output: string;
        if (separator === 'json') {
          output = JSON.stringify(results, null, 2);