from sqlalchemy import create_engine, inspect engine = create_engine('sqlite:////home/kosieh/db.sqlite') inspector = inspect(engine) schemas = inspector.get_schema_names() for schema in schemas: print(f"Schema: {schema}") for tableName in inspector.get_table_names(schema = schema): print(f"Table name: {tableName}") for column in inspector.get_columns(tableName, schema = schema): print(f"Column: {column}")