{"name":"WWG REST API Server","version":"0.5.0","description":"REST API for StorQuest self-storage data","databases":["Customer_Geo_Distribution","FSR","G5","GA","ProForma","Reviews","RMTools","RV Sites","sE","Sites","Stortrack","STORQ"],"database_count":12,"total_tables":268,"endpoints":{"/health":"Check database connectivity","/sites":"List StorQuest facilities","/sites/{site_number}":"Get specific site details","/analytics/ecri/{store_number}":"ECRI impact analysis (eligible tenants, revenue uplift, escalations)","/analytics/portfolio":"Portfolio statistics","/analytics/summary/{store_number}":"Store dashboard: occupancy, NOI, move activity, AR aging","/analytics/occupancy/{store_number}":"Occupancy metrics (handles UUID joins)","/analytics/occupancy_by_unit_group/{store_number}":"Occupancy by unit group (5x5, 10x10, etc.)","/analytics/noi/{store_number}":"NOI calculation (handles GP account codes)","/analytics/move_activity/{store_number}":"Move-in/out activity (handles date filtering)","/analytics/expenses/{store_number}":"Expense breakdown by category (handles GP account codes)","/analytics/budget/{store_number}":"Budget vs actual with variance analysis","/analytics/portfolio/occupancy":"Portfolio occupancy across all stores (filter by state/dm)","/analytics/portfolio/noi":"Portfolio NOI across all stores (filter by state/dm)","/analytics/portfolio/budget":"Portfolio budget vs actual across all stores (filter by state/dm)","/analytics/portfolio/ar_aging":"AR aging buckets across all stores (filter by state/dm)","/databases":"List all databases","/tables/{database}":"List tables in database","/schema/{database}":"Get schema details","/schema/search/{term}":"Search across schemas","/query/universal":"Custom queries","/analytics/pricing/{store_number}":"Pricing intel: occupancy, rates, trajectories, comps","/storedge/report/{store_number}":"Pull live StorEdge report (rent roll) as CSV-ready data","/storedge/*":"StorEDGE facility data","/storedge/company/*":"StorEDGE company data"},"documentation":"/docs","mcp_server":"https://mcp.wwgmcpserver.com/sse"}