import duckdb
c = duckdb.connect(r"C:\Users\sayan\Downloads\FinAi\data\mbf.duckdb", read_only=True)
rows = c.execute(
    "SELECT table_name, table_type FROM information_schema.tables "
    "WHERE table_schema='main' ORDER BY 1"
).fetchall()
print(f"TABLES ({len(rows)}):")
for r in rows:
    try:
        n = c.execute(f'SELECT COUNT(*) FROM "{r[0]}"').fetchone()[0]
    except Exception as e:  # noqa: BLE001
        n = f"ERR {e}"
    print(f"  {r[0]:<35} {r[1]:<10} rows={n}")