db-schema

Schema-aware SQL querying translates business questions into correct PostgreSQL SELECT queries by mapping Omni CRM entity relationships across Tickets, Projects, CRM Inbox, and Workforce domains. It uses a schema reference to ensure accurate cross-domain joins for analytics and reporting.

Yes, schema-aware SQL querying supports PostGIS proximity and aggregation analytics across network and fiber entities. It correctly joins spatial data with subscriber and work order tables to produce geographic insights using safe, read-only PostgreSQL SELECT statements.

Generating SLA and compliance reports requires schema-aware SQL queries that join ticket data with workforce and CRM entities. The approach applies soft-delete filtering and correct enum handling to ensure production-safe, accurate SELECT queries for reporting metrics.

Yes, schema-aware SQL querying enforces read-only execution via the omni-db MCP server using a restricted DSN. It strictly limits operations to SELECT queries, preventing database writes while providing guidance on soft-delete filtering and LIMIT usage for safe analytics.

Cross-domain relationship guidance maps people, subscribers, tickets, and work orders entities to enable correct PostgreSQL joins. Schema-aware querying translates these complex relationships into safe SELECT statements, bridging CRM, workforce, and network domains for comprehensive analytics.