sql_query
Run read-only SQL queries on Australian development application records to analyze property data, filter by council, status, or location, and extract insights from DA Leads.
Instructions
Run a read-only SQL query against DA records. Pro plan only.
Query the 'das' table with columns: id, address, address_suburb, address_postcode, council_name, council_reference, state, trade_category, sub_category, application_type, is_residential, lodgement_date, status, cost_of_development, decision_date, decision_status, on_notice_from, on_notice_to, number_of_dwellings, lot_count, land_use, building_type, storeys, latitude, longitude, data_source, date_fetched, documents, info_url. Description and summary are deliberately unavailable because council free text may contain personal contact details.
Max 1000 rows. 10 second timeout. SELECT only.
Args: query: SQL SELECT query using table name 'das' params: Optional parameters for %s placeholders
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| params | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |