sqlite_introspect.py

import sqlite3

# Path to your SQLite file
sqlite_file = 'your_database.sqlite'

# Connect to the SQLite database
conn = sqlite3.connect(sqlite_file)
cursor = conn.cursor()

# Get the table names
cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
tables = cursor.fetchall()

# Loop through the tables
for table in tables:
    table_name = table[0]
    print(f"Table: {table_name}")
    print("Columns:")
    
    # Get the column names for the current table
    cursor.execute(f"PRAGMA table_info({table_name});")
    columns = cursor.fetchall()
    
    # Loop through the columns
    for column in columns:
        column_name = column[1]
        print(f"- {column_name}")
    
    print()  # Add an empty line between tables

# Close the database connection
conn.close()