Data View Export

Data View/Export

Use this page for quick querying and export workflows from workspace SQLite data.

If you are still onboarding, start with Getting Started.

What This Covers

• Querying saved data with data sql
• Exporting reports with data export
• Picking output formats and paths

Query Data (SQL)

Run SQL directly against the local workspace databases.

data sql --db service "SELECT * FROM identity_policies LIMIT 20"
data sql --db metadata "SELECT * FROM workspaces"

Notes:

• --db service targets module output tables.
• --db metadata targets workspace/session metadata tables.

Export Data

Supported formats:

• csv
• json
• excel (requires the optional [excel] extra: pip install "ocinferno[excel]")
• treeimage

Examples:

data export json
data export excel
data export csv --out-dir ./exports/csv
data export treeimage --out-file ./exports/tenant_tree.png

Common Review Flow

modules run enum_all --comp
data export excel --out-dir ./report_excel
data export json --out-dir ./report_json

Output Paths

• Default root: ./ocinferno_output
• Exports are written under the active workspace path unless --out-dir / --out-file is provided

Related Pages

• Workspace commands and config defaults: Workspace Instructions
• Module flags and execution details: Orchestration Module Reference
• Static findings catalog: ConfigChecker - Static Config Checks