Function getSchemaDetailed

packages/core/src/query/message-queries.ts:454–483

(db: DatabaseAdapter)

 * Returns table names + full column info via PRAGMA table_info.
 */
export function getSchemaDetailed(db: DatabaseAdapter): TableSchema[] {
  const tables = db
    .prepare(
      `SELECT name FROM sqlite_master
       WHERE type='table' AND name NOT LIKE 'sqlite_%'
       ORDER BY name`
    )
    .all() as Array<{ name: string }>

  return tables.map((table) => {
    const columns = db.prepare(`PRAGMA table_info('${table.name}')`).all() as Array<{
      cid: number
      name: string
      type: string
      notnull: number
      dflt_value: unknown
      pk: number
    }>

    return {
      name: table.name,
      columns: columns.map((col) => ({
        name: col.name,
        type: col.type,
        notnull: col.notnull === 1,
        pk: col.pk === 1,
      })),
    }
  })
}

// ==================== Context & Conversation Queries ====================