Query the BuildAI PostgreSQL database (read-only). Returns results as JSON for construction project data — projects, RFIs, submittals, budgets, change orders, daily logs, punch lists, insurance, vendors, pay applications.
The English summary is being prepared. Showing the original description.
Run score Not tested
See how to installReview the instructions the agent will receive before you install.
Execute read-only SQL queries against the BuildAI PostgreSQL database (buildai_demo).
bash command:"cd /home/apoorvgarg/buildai/packages/engine/skills/buildai-database && bash query.sh 'SELECT * FROM projects LIMIT 5'"
The script takes a single argument: a SQL query string.
Safety:
| Table | Description |
|---|---|
projects | Construction projects with status, contract sums, dates, stakeholders |
rfis | Requests for Information — open/closed/void, with priority and assignee |
submittals | Material/shop drawing submittals with approval tracking |
budget_line_items | Cost codes with original/revised/committed/actual budget breakdowns |
change_orders | Change order packages with amounts and reasons |
daily_logs | Daily site logs — weather, workforce, delays, safety incidents |
punch_list_items | Punch list items with status and priority |
insurance_certs | Vendor insurance certificates with expiration tracking |
vendors | Subcontractors/vendors with contract amounts and payments |
pay_applications | Payment applications (AIA G702/G703 style) |
| View | Best For |
|---|---|
v_project_dashboard | Project overview — open RFIs, pending submittals, expiring certs |
v_overdue_rfis | Overdue RFIs with days overdue |
v_expiring_insurance | Insurance certs expiring within 90 days |
v_project_budget_summary | Budget totals with variance analysis |
projects: id, name, address, city, state, status (active/completed/on_hold), contract_sum, start_date, projected_completion, project_type
rfis: id, project_id, number, subject, status (open/closed/void), priority (normal/urgent/critical), assigned_to, due_date, days_open
budget_line_items: id, project_id, cost_code, description, original_budget, revised_budget, committed_costs, actual_costs, projected_final, variance, variance_percent
-- Active projects overview
SELECT * FROM v_project_dashboard WHERE status = 'active';
-- Overdue RFIs
SELECT * FROM v_overdue_rfis ORDER BY days_overdue DESC;
-- Budget overruns
SELECT * FROM v_project_budget_summary WHERE total_variance < 0;
-- Expiring insurance in next 30 days
SELECT * FROM v_expiring_insurance WHERE days_until_expiration <= 30;
-- Workforce trends for a project
SELECT log_date, workforce_count, weather FROM daily_logs
WHERE project_id = 1 ORDER BY log_date DESC LIMIT 14;
| Variable | Default | Description |
|---|---|---|
DB_HOST | /var/run/postgresql | PostgreSQL host |
DB_PORT | 5432 | PostgreSQL port |
DB_NAME | buildai_demo | Database name |
DB_USER | $USER | Database user |
DB_PASSWORD | (none) | Database password (optional for local peer auth) |
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Complete architecture reference for the A3 insurance platform — file locations, data flow, conventions, microservice map, and fullstack patterns
The English summary is being prepared. Showing the original description.
Drafts U.S. commercial real estate access and indemnity (right-of-entry) agreements for pre-closing due diligence. Covers license grants, non-invasive vs invasive testing gates, insurance/endorsement requirements, indemnity with discovery carve-outs, restoration and lien remedies, confidentiality, and anti-indemnity guardrails. Trigger: access agreement, right of entry, due diligence access, Phase I/II, invasive testing, pre-PSA site inspection.
The English summary is being prepared. Showing the original description.
当用户需要对意外险投保问卷进行专业、结构化的核保审查，提取职业类别、工作环境、作业内容、危险活动参与情况、交通出行习惯、特殊工作暴露及其他可能影响意外险承保判断的高风险信息，并生成适合意外险核保、补问流转和风险分层处理的结构化分析结果时使用本 skill。
The English summary is being prepared. Showing the original description.
Inspect, schema, and fill true AcroForm PDFs using sciClaw's pdf_form_inspect, pdf_form_schema, and pdf_form_fill tools. Use when: (1) checking whether a PDF is a real fillable AcroForm, (2) listing form field names, types, and choices, (3) filling a supported form from structured values, (4) preparing reviewable insurance, legal, administrative, or clinical form drafts, (5) reporting skipped fields or unused input keys after a fill. Do not use for scanned PDFs, OCR tasks, or XFA-only forms.
The English summary is being prepared. Showing the original description.
Guide actuarial analysis for insurance pricing. TRIGGERS - Use when user needs help with actuarial-analysis related tasks.
The English summary is being prepared. Showing the original description.
Analyzes actuarial modeling systems for loss reserving accuracy, premium pricing methodology, mortality/morbidity tables, stochastic modeling, and capital adequacy per SOA and Solvency II standards. USE THIS SKILL WHEN: - You need to review or audit actuarial models (reserving, pricing, capital) - Someone asks about loss triangle analysis or reserve adequacy - You are evaluating IBNR calculations, chain ladder methods, or Bornhuetter-Ferguson - A project involves insurance pricing, GLM rating models, or ratemaking - You need to assess Solvency II SCR calculations or RBC compliance - Someone mentions actuarial opinions, ASOP compliance, or SOA standards - You are reviewing stochastic models, ESG configurations, or DFA frameworks - A codebase uses actuarial libraries (chainladder, lifetables, ChainLadder R package) TRIGGER PHRASES: "actuarial", "loss reserving", "IBNR", "chain ladder", "premium pricing", "mortality table", "Solvency II", "capital adequacy", "ratemaking", "GLM pricing", "risk-based capital", "reserve analysis", "actuarial opinion"
The English summary is being prepared. Showing the original description.