Data & Analytics

Build SQL queries for construction databases. Generate optimized SQL queries for construction data retrieval

Automate construction data workflows. Build ETL pipelines and DAG workflows for recurring tasks.

Automated cost estimation from BIM models using DDC CWICR database with 55,719 work items. AI classification + vector search for accurate pricing.

Extract structured data from construction documents using LLMs. Process RFIs, submittals, contracts, specifications. Convert unstructured PDFs to structured JSON/Excel.

Build validation rules for construction data. Create RegEx and logic-based validation for BIM elements, cost codes, and schedule data.

Apply machine learning for construction project risk assessment. Predict schedule delays, cost overruns, and safety incidents using historical data and project characteristics.

Get smart database index suggestions from query patterns. Use when queries are slow.

Query Supabase projects - count users, list signups, check stats. Use for database queries and user analytics.

Generate SQL migration files from ORM schemas. Use when managing database changes.

Convert AutoCAD DWG files (1983-2026) to Excel databases using DwgExporter CLI. Extract layers, blocks, attributes, and geometry data without Autodesk licenses.

Extract and analyze data from construction ERP systems. Pull project data for analytics, reporting, and integration.

Backup and restore OpenClaw data. Use when user asks to create backups, set up automatic backup schedules, restore from backup, or manage backup rotation. Handles ~/.openclaw directory archiving with proper exclusions.