
DuckDB as an analytics and OLAP engine. Covers analytical query patterns, Parquet/Arrow analytics, BI tool integration (Tableau, Power BI, Superset via JDBC/ODBC), local-first analytics, and data warehouse replacement at small-to-medium scale. Routes to the primary DuckDB agent for core engine expertise. WHEN: "DuckDB analytics", "DuckDB OLAP", "DuckDB Parquet analytics", "DuckDB BI", "DuckDB Tableau", "DuckDB Power BI", "DuckDB Superset", "DuckDB data warehouse", "local analytics", "in-process analytics", "DuckDB dashboard", "embedded analytics engine", "DuckDB reporting", "DuckDB JDBC", "DuckDB ODBC".
Expert agent for ThoughtSpot across all deployment models (Cloud and Software). Provides deep expertise in search-based analytics, the search-token architecture, Spotter AI assistant, SpotIQ automated insights, Liveboards, Models (semantic layer), TML (ThoughtSpot Modeling Language), ThoughtSpot Everywhere (embedded analytics with Visual Embed SDK), REST API v2.0, Falcon in-memory engine, SpotCache, cloud data warehouse connectivity, row/column-level security, and performance optimization. WHEN: "ThoughtSpot", "SpotIQ", "Spotter", "Liveboard", "ThoughtSpot Everywhere", "Visual Embed SDK", "TML", "ThoughtSpot Modeling Language", "search analytics", "ThoughtSpot search", "SpotCache", "Falcon engine", "ThoughtSpot embedding", "SpotterViz", "SpotterModel", "SpotterCode", "ThoughtSpot Cloud", "ThoughtSpot Models", "ThoughtSpot Worksheets", "Spotter Semantics", "ThoughtSpot MCP", "Analyst Studio", "ThoughtSpot Monitor".
Version-specific expert for SQL Server Analysis Services 2025 (compatibility level 1700). Covers Horizontal Fusion, selection expressions, enhanced DirectQuery parallelism, LINEST/LINESTX, binary XML, and improved diagnostics. WHEN: "SSAS 2025", "SQL Server 2025 Analysis Services", "compatibility level 1700", "Horizontal Fusion", "selection expressions", "LINEST", "LINESTX".
Version-specific expert for SQL Server Analysis Services 2019 (compatibility level 1500). Covers calculation groups, native many-to-many relationships, query interleaving, and governance settings. WHEN: "SSAS 2019", "SQL Server 2019 Analysis Services", "compatibility level 1500", "calculation groups", "calculation items".
Version-specific expert for SSRS 2022 (SQL Server 2022). Covers Angular portal redesign, TLS 1.3 support, mobile report removal, and significance as the FINAL standalone SSRS release. WHEN: "SSRS 2022", "SQL Server 2022 Reporting Services", "final SSRS", "SSRS Angular portal", "SSRS TLS 1.3".
Version-specific expert for Tableau 2026.1 (current, March 2026). Covers REST API Connector, AI-assisted color palettes, mixed geometry maps, Pulse on Dashboards, SCIM with OIDC, IP Filtering self-service, and deprecated connectors. WHEN: "Tableau 2026", "Tableau 2026.1", "latest Tableau", "current Tableau", "REST API Connector", "Pulse on Dashboards", "AI color palettes".
Version-specific expert for SSRS 2019 (SQL Server 2019). Covers Azure AD Application Proxy integration, accessibility improvements, and support lifecycle. WHEN: "SSRS 2019", "SQL Server 2019 Reporting Services", "SSRS Azure AD".
Google Cloud Looker expert. Deep expertise in LookML semantic modeling, Explores, derived tables, caching with datagroups, embedded analytics, governance, Git-based development workflows, and Gemini AI integration. WHEN: "Looker", "LookML", "LookML model", "LookML view", "LookML explore", "LookML refinement", "LookML extends", "Looker Explore", "Looker dashboard", "Looker embed", "Looker SDK", "Looker API", "Looker Studio", "Looker Studio Pro", "Open SQL Interface", "Looker semantic layer", "datagroup", "PDT", "persistent derived table", "derived table", "aggregate table", "aggregate awareness", "Looker connection", "Looker permissions", "access_filter", "access_grant", "Looker Blocks", "Looker Marketplace", "Looker Extension", "Extension Framework", "Looker Gemini", "Conversational Analytics", "LookML Assistant", "Looker Core", "customer-hosted Looker".
Metabase expert. Deep expertise in question design, models, dashboards, embedding (static, full-app, SDK), permissions and data sandboxing, caching, Data Studio semantic layer, Transforms, and Metabot AI. WHEN: "Metabase", "Metabase question", "Metabase query builder", "Metabase SQL", "Metabase model", "Metabase dashboard", "Metabase embed", "Metabase SDK", "Metabase embedding", "static embedding", "guest embed", "full-app embedding", "Metabase permissions", "data sandboxing", "Metabase collection", "Metabase caching", "Metabase API", "Metabase Docker", "Metabase JAR", "Metabase Cloud", "Metabase Pro", "Metabase Enterprise", "Metabot", "Metabase Data Studio", "Metabase transform", "Metabase segment", "Metabase measure", "Metabase tenant", "Metabase remote sync", "Metabase filter", "Metabase subscription".
Socket.IO 4.x specialist covering namespaces, rooms, acknowledgements, adapters, scaling, connection state recovery, middleware, TypeScript types, and multi-server deployment. WHEN: "Socket.IO", "socket.io", "rooms", "namespaces", "Socket.IO adapter", "Redis adapter", "Socket.IO scaling", "Socket.IO middleware", "Socket.IO authentication", "Engine.IO", "Socket.IO reconnect", "emitWithAck", "Socket.IO admin", "connection state recovery", "volatile emit", "Socket.IO TypeScript".
Version-specific expert for SQL Server Analysis Services 2022 (compatibility level 1600). Covers parallel DirectQuery, composite models, object-level security, and MDX Fusion. WHEN: "SSAS 2022", "SQL Server 2022 Analysis Services", "compatibility level 1600", "parallel DirectQuery", "object-level security", "OLS", "MDX Fusion".
Microsoft Power BI expert. Deep expertise in semantic models, DAX, Power Query (M), storage modes, Fabric integration, report design, and governance. WHEN: "Power BI", "Power BI Desktop", "Power BI Service", "DAX", "DAX formula", "DAX measure", "CALCULATE", "filter context", "row context", "Power Query", "M language", "query folding", "VertiPaq", "DirectQuery", "Direct Lake", "semantic model", "Power BI dataset", "Power BI report", "Power BI dashboard", "Power BI Embedded", "Power BI gateway", "Power BI refresh", "paginated report", "RDL", "PBIX", "PBIR", "Power BI capacity", "PPU", "Power BI Premium", "Fabric Power BI", "Power BI Copilot", "Power BI RLS", "deployment pipeline Power BI".
Top-level routing agent for ALL data analytics, business intelligence, and reporting technologies. Provides cross-platform expertise in data visualization, OLAP, semantic modeling, dashboard design, and reporting. WHEN: "analytics", "BI", "business intelligence", "dashboard", "reporting", "data visualization", "OLAP", "Power BI", "Tableau", "Grafana", "Superset", "Metabase", "SSAS", "SSRS", "Looker", "Qlik", "ThoughtSpot", "star schema", "measures", "KPI".
Version-specific expert for Tableau 2025.x releases (2025.1, 2025.2, 2025.3). Covers Tableau Einstein integration, Pulse enhancements, VizQL Data Service, Unified Access Tokens, and Tableau Semantics GA. WHEN: "Tableau 2025", "Tableau 2025.1", "Tableau 2025.2", "Tableau 2025.3", "Tableau Einstein", "VizQL Data Service", "Unified Access Tokens", "UAT".
Expert agent for Qlik Sense across all deployment models (Cloud, Enterprise on Windows, Enterprise on Kubernetes). Provides deep expertise in the QIX Associative Engine, data modeling (star schema, synthetic keys, circular references), set analysis, load scripting, app design (DAR pattern), Insight Advisor, Qlik Answers, Qlik Predict, embedding (qlik-embed, nebula.js, enigma.js), section access, governance, and performance optimization. WHEN: "Qlik", "Qlik Sense", "QIX Engine", "Qlik Cloud", "Qlik Associative Engine", "set analysis", "QVD", "Qlik load script", "Qlik NPrinting", "Qlik Automate", "Qlik Reporting Service", "Insight Advisor", "Qlik Answers", "Qlik Predict", "qlik-embed", "nebula.js", "enigma.js", "master items", "section access", "Qlik Talend", ".qvf", "synthetic key", "associative model".
Expert agent for SQL Server Analysis Services (SSAS) across all versions. Provides deep expertise in Tabular and Multidimensional models, VertiPaq engine, DAX/MDX, processing strategies, and deployment. WHEN: "SSAS", "Analysis Services", "Tabular model", "Multidimensional model", "VertiPaq", "DAX query", "DAX measure", "MDX query", "OLAP cube", "DirectQuery", "calculation group", "SSAS processing", "SSAS partition", "row-level security RLS", "XMLA endpoint", "Azure Analysis Services", "AAS", "semantic model", "TMSL", "Tabular Editor", "DAX Studio", "MOLAP", "ROLAP".
Version-specific expert for SQL Server 2025 reporting, where SSRS is replaced by Power BI Report Server (PBIRS). Covers migration guidance, licensing changes, and the SSRS-to-PBIRS transition. WHEN: "SSRS 2025", "SQL Server 2025 reporting", "SSRS replacement", "SSRS end of life", "SSRS to PBIRS", "SSRS migration to Power BI Report Server".
Expert agent for SQL Server Reporting Services (SSRS) across all versions. Provides deep expertise in RDL report design, data sources, subscriptions, rendering, security, deployment, and migration to Power BI Report Server. WHEN: "SSRS", "SQL Server Reporting Services", "RDL report", "Report Builder", "ReportServer", "SSRS subscription", "paginated report", "report definition language", "SSRS web portal", "rs.exe", "ReportingServicesTools", "SSRS migration", "Power BI Report Server", "PBIRS".
gRPC 1.x specialist covering Protocol Buffers, service definitions, streaming patterns, channels, interceptors, metadata, deadlines, error model, load balancing, health checking, retry policies, and performance tuning. WHEN: "gRPC", "protobuf", "Protocol Buffers", "proto3", "protoc", "Buf", "gRPC streaming", "bidirectional streaming", "gRPC interceptor", "gRPC metadata", "gRPC deadline", "gRPC health check", "gRPC load balancing", "gRPC-Web", "Connect protocol", "grpc-gateway", "service config", "retry policy", "hedging".
Expert agent for Tableau across all versions. Provides deep expertise in VizQL, data modeling (relationships vs joins), LOD expressions, dashboard design, Tableau Server/Cloud administration, Prep Builder, Pulse, embedding, and performance optimization. WHEN: "Tableau", "VizQL", "Tableau Desktop", "Tableau Server", "Tableau Cloud", "Tableau Prep", "Tableau Pulse", "LOD expression", "FIXED expression", "INCLUDE expression", "EXCLUDE expression", "table calculation", "Tableau extract", ".hyper", "Tableau Bridge", "Tableau embedding", "Connected Apps", "Tableau Semantics", "Tableau Agent", "Tableau Einstein".
Top-level routing agent for ALL API design and real-time communication technologies. Provides cross-protocol expertise in request/response APIs (REST, GraphQL, gRPC, OData) and real-time transports (WebSocket, SSE, SignalR, Socket.IO). WHEN: "API design", "REST API", "GraphQL", "gRPC", "OData", "WebSocket", "SSE", "Server-Sent Events", "SignalR", "Socket.IO", "real-time", "API gateway", "protocol comparison", "REST vs GraphQL", "WebSocket vs SSE", "API versioning", "API authentication", "CORS", "streaming API".
GraphQL specialist covering schema design, type system, execution model, Apollo Server/Client, Federation 2.x, Relay, DataLoader, persisted queries, subscriptions, and performance optimization. WHEN: "GraphQL", "Apollo Server", "Apollo Client", "Federation", "subgraph", "supergraph", "DataLoader", "N+1", "schema design", "SDL", "resolver", "mutation", "subscription", "Relay", "Strawberry", "Hot Chocolate", "Mercurius", "graphql-yoga", "persisted queries", "introspection", "GraphQL Codegen", "Pothos", "TypeGraphQL".
OData 4.x specialist covering Entity Data Model, system query options ($filter, $select, $expand, $orderby, $apply), CSDL metadata, batch requests, functions/actions, and Microsoft/SAP ecosystem integration. WHEN: "OData", "$filter", "$select", "$expand", "$orderby", "$apply", "$count", "$search", "$batch", "EDM", "CSDL", "$metadata", "OData query", "lambda operator", "any", "all", "navigation property", "deep insert", "Power BI OData", "SAP OData", "OData action", "OData function".
Expert agent for Apache Superset (5.x through 6.x). Provides deep expertise in SQL Lab, chart exploration, dashboard design, database connectivity (50+ databases via SQLAlchemy), caching (Redis multi-tier), async queries (Celery), Jinja templating, security (RBAC/RLS/OAuth/LDAP), embedding (guest tokens), Kubernetes deployment, and performance optimization. WHEN: "Superset", "Apache Superset", "SQL Lab", "Superset dashboard", "Superset chart", "Superset embedding", "superset_config.py", "Preset", "Superset caching", "Superset Celery", "Superset Redis", "Superset RBAC", "Superset RLS", "Superset Jinja", "Superset Helm", "Superset Kubernetes", "ECharts Superset", "Superset feature flags", "Superset native filters", "Superset cross-filtering".
ASP.NET Core SignalR specialist covering .NET 8, 9, and 10. Deep expertise in hubs, transport negotiation, groups, streaming, authentication, Azure SignalR Service, Redis backplane, MessagePack, and scaling patterns. WHEN: "SignalR", "hub", "HubContext", "SignalR group", "SignalR streaming", "Azure SignalR Service", "SignalR backplane", "SignalR Redis", "SignalR authentication", "SignalR reconnect", "MessagePack", "SignalR scale-out", "strongly typed hub", "IHubContext", "SignalR .NET", "Hub filter".
WebSocket protocol specialist covering RFC 6455, opening handshake, frame format, close codes, extensions (permessage-deflate), subprotocols, browser API, server implementations, authentication patterns, and reconnection strategies. WHEN: "WebSocket", "ws", "wss", "RFC 6455", "WebSocket handshake", "WebSocket close code", "WebSocket frame", "ping pong", "permessage-deflate", "WebSocket subprotocol", "WebSocket authentication", "WebSocket reconnect", "bufferedAmount", "WebSocket binary", "WebSocket proxy", "1006", "1000", "1001".
REST API design specialist covering OpenAPI 3.1, HTTP semantics, resource design, pagination, caching, content negotiation, CORS, API gateways, rate limiting, and error handling. WHEN: "REST API", "OpenAPI", "Swagger", "HTTP methods", "status codes", "CORS", "pagination", "API versioning", "rate limiting", "API gateway", "Kong", "APIM", "API design", "HATEOAS", "content negotiation", "ETag", "caching", "idempotency key", "RFC 9457", "Problem Details", "JSON:API", "HAL".
Grafana expert for analytics and dashboarding use cases. Deep expertise in dashboard design, data source configuration, alerting, provisioning as code, plugin management, and the LGTM observability stack. WHEN: "Grafana", "Grafana dashboard", "Grafana panel", "Grafana alerting", "Grafana data source", "Grafana Cloud", "Grafana OSS", "Grafana Enterprise", "Grafana provisioning", "Grafana Terraform", "Grafana Operator", "Git Sync Grafana", "PromQL", "LogQL", "TraceQL", "Loki", "Tempo", "Mimir", "Grafana Alloy", "LGTM stack", "Grafana plugin", "Grafana variable", "Grafana template", "grafana-cli", "Grafana alert rule", "notification policy", "contact point", "mute timing", "recording rule", "Grafana embed".
Server-Sent Events specialist covering the EventSource API, text/event-stream format, auto-reconnection, Last-Event-ID resumption, named events, server implementations across Node.js/Python/Go/.NET/Rust, LLM streaming patterns, and infrastructure configuration. WHEN: "SSE", "Server-Sent Events", "EventSource", "text/event-stream", "Last-Event-ID", "event stream", "LLM streaming", "AI streaming", "token streaming", "server push", "live feed", "log streaming", "progress events", "retry field", "keepalive", "MCP transport".
Top-level routing agent for ALL backend web framework and REST API technologies. Provides cross-framework expertise in API design, HTTP semantics, authentication, framework selection, and performance patterns. WHEN: "backend framework", "REST API", "web API", "which framework", "Express vs FastAPI", "Django vs Rails", "Spring Boot vs", "API design", "backend architecture", "framework comparison", "API authentication", "API versioning", "middleware", "API performance".