Enable Mastra Observability for long-term development

[MabudAlam]

Problem

Mastra observability features (traces, entity discovery, service names) are throwing 'Storage is not available' errors. This prevents proper debugging and development visibility into agent workflows.

Requirements

1. Local trace persistence - Store traces in a local database for development
2. Observability endpoints working: /observability/discovery/entity-names, /observability/discovery/environments, /observability/discovery/service-names, /observability/traces
3. Studio integration - View traces via Mastra Studio observability tab
4. Production-ready configuration - Support for high-volume production with ClickHouse

Technical Approach

Use LibSQLStore for local development with MastraStorageExporter. For production, route observability to ClickHouse via composite storage.

References

• https://mastra.ai/docs/observability/tracing/exporters/mastra-storage
• https://mastra.ai/reference/storage/composite