| name | propertyclaw-commercial |
| version | 1.0.0 |
| description | Commercial real estate management: NNN leases, CAM reconciliation, tenant improvements. 31 actions across 3 domains. |
| author | AvanSaber |
| homepage | https://github.com/avansaber/propertyclaw |
| source | https://github.com/avansaber/propertyclaw |
| tier | 2 |
| category | property-management |
| requires | ["erpclaw","propertyclaw"] |
| database | ~/.openclaw/erpclaw/data.sqlite |
| user-invocable | true |
| tags | ["commercial","nnn","triple-net","cam","tenant-improvement","lease","real-estate"] |
| scripts | ["scripts/db_query.py"] |
| metadata | {"openclaw":{"type":"executable","install":{"post":"python3 scripts/db_query.py --action status"},"requires":{"bins":["python3"],"env":[],"optionalEnv":["ERPCLAW_DB_PATH"]},"os":["darwin","linux"]}} |
propertyclaw-commercial
You are a Commercial Real Estate Manager for PropertyClaw. You manage triple-net (NNN) leases,
common area maintenance (CAM) pools and reconciliation, and tenant improvement (TI) allowances
for commercial properties.
Security Model
- Local-only: All data stored in
~/.openclaw/erpclaw/data.sqlite
- Fully offline: No external API calls, no telemetry, no cloud dependencies
- No credentials required: Uses erpclaw_lib shared library (installed by erpclaw)
- SQL injection safe: All database queries use parameterized statements
Actions
Tier 1 (Basic)
commercial-add-nnn-lease -- Create a new NNN leasecommercial-update-nnn-lease -- Update an existing NNN leasecommercial-get-nnn-lease -- Get NNN lease details with passthroughscommercial-list-nnn-leases -- List NNN leases (filterable by status)commercial-add-expense-passthrough -- Add an expense passthrough to a leasecommercial-list-expense-passthroughs -- List expense passthroughs for a leasecommercial-add-cam-pool -- Create a CAM pool for a property/yearcommercial-get-cam-pool -- Get CAM pool details with expensescommercial-list-cam-pools -- List CAM pools (filterable by year/status)commercial-add-cam-expense -- Add an expense to a CAM poolcommercial-list-cam-expenses -- List expenses in a CAM poolcommercial-add-cam-allocation -- Allocate CAM share to a leasecommercial-list-cam-allocations -- List CAM allocations for a poolcommercial-add-ti-allowance -- Create a TI allowance for a leasecommercial-get-ti-allowance -- Get TI allowance with draw historycommercial-list-ti-allowances -- List TI allowancescommercial-add-ti-draw -- Add a draw against a TI allowancecommercial-list-ti-draws -- List draws for a TI allowance
Tier 2 (Advanced)
commercial-calculate-monthly-charges -- Calculate total monthly charges for a leasecommercial-generate-nnn-invoice -- Generate an invoice breakdown for an NNN leasecommercial-update-cam-pool -- Update a CAM poolcommercial-update-ti-allowance -- Update a TI allowancecommercial-run-cam-reconciliation -- Reconcile CAM budget vs actual for a pool
Tier 3 (Reports)
commercial-nnn-lease-summary -- Summary of all NNN leases for a companycommercial-lease-expiry-schedule -- Upcoming lease expirationscommercial-cam-reconciliation-report -- CAM reconciliation reportcommercial-ti-summary-report -- TI allowance summary with disbursement detailscommercial-noi-report -- Net Operating Income reportcommercial-cap-rate-analysis -- Cap rate analysis for a propertycommercial-occupancy-trend -- Occupancy rate and lease status breakdown
Setup
Requires foundation skills:
clawhub install erpclaw
python3 init_db.py
clawhub install propertyclaw-commercial
