query_simulation_table
Retrieve tabular data from the last simulation's SQL output to analyze energy use, envelope, HVAC sizing, and comfort beyond standard diagnostics.
Instructions
Query tabular report data from the last simulation's SQL output.
Use this for deeper analysis beyond the structured diagnostics in
idfkit://simulation/results. Tabular data covers every EnergyPlus
summary report: energy use, envelope, HVAC sizing, comfort, and more.
Omit table_name to retrieve all tables within a report at once.
To discover available report names call list_simulation_reports first.
Common report names:
AnnualBuildingUtilityPerformanceSummary— site/source energy, end uses, EUISystemSummary— unmet hours, HVAC sizingEnvelopeSummary— U-values, areas, orientationsEquipmentSummary— HVAC component sizingZoneComponentLoadSummary— peak heating/cooling loads by zoneLightingSummary— lighting power density
Preconditions: simulation completed with SQL output available (sql_available: true
in idfkit://simulation/results).
Side effects: none — read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| row_name | No | Filter to a specific row label. | |
| table_name | No | Table name within the report (e.g. 'End Uses', 'Time Setpoint Not Met'). Omit to return all tables in the report. | |
| column_name | No | Filter to a specific column label. | |
| report_name | Yes | Report name (e.g. 'AnnualBuildingUtilityPerformanceSummary', 'SystemSummary'). Use list_simulation_reports to discover available names. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| row_count | Yes | ||
| table_name | Yes | ||
| report_name | Yes |