OAuth 2.1 Resource Server with MS Entra ID (via OAuth Proxy)
POST /oauth/register - Dynamic Client RegistrationGET /oauth/authorize - Authorization EndpointPOST /oauth/token - Token EndpointPOST /mcp - MCP endpoint (Bearer token required) Auth RequiredREST API for Excel, Power BI, and external tools. Use API key or OAuth token.
GET /api/data/schema - Database schemaGET /api/data/queries - List saved queriesGET /api/data/queries/{id} - Execute query (OData params supported)GET /api/data/queries/{id}/export?format=xlsx - Export to Excel/CSVGET /api/data/odata/queries/{id} - OData endpoint for Power BIGET /api/charts/{id} - Interactive chart (HTML)GET /api/charts/{id}/config - Chart.js configurationGET /api/charts/{id}/data - Chart data (JSON)GET /api/charts/{id}/export?format=csv - Export chart dataGET /api/dashboards/{id} - Interactive dashboard (HTML)GET /api/dashboards/{id}/data/{source} - Dashboard data sourceGET /api/dashboards/{id}/metadata - Dashboard metadataGET /api/dashboards - List dashboards Authlist_database_connections - List configured DB connectionsadd_database_connection - Add new SQL Server connectiontest_database_connection - Test connectionremove_database_connection - Remove connectionget_database_schema - Complete DB schema with relationshipsget_table_schema - Table details with sample valuesget_table_relationships - Foreign key relationshipscreate_query_definition - Create virtual view from JSONvalidate_query_definition - Validate without executingexecute_query - Run saved querylist_saved_queries - List user's queriesdelete_query - Delete saved queryexecute_raw_sql - Execute raw SQL (CTEs, window functions, PIVOT)validate_raw_sql - Validate raw SQL without executingexport_to_excel - Export to XLSXexport_to_csv - Export to CSVget_data_api_url - Get URL for Excel/Power BIcreate_api_key - Create API key for external toolslist_api_keys - List API keysrevoke_api_key - Revoke API keycreate_chart - Create interactive chartlist_charts - List user's chartsget_chart_url - Get chart URLsrefresh_chart_data - Refresh chart datadelete_chart - Delete chartcreate_dashboard - Create dashboard with HTML/JSupdate_dashboard - Update dashboard contentlist_dashboards - List user's dashboardsget_dashboard_url - Get dashboard URLdelete_dashboard - Delete dashboardpublish_query_as_tool - Publish a query as a standalone MCP toolunpublish_tool - Remove a published toollist_published_tools - List your published toolsupdate_published_tool - Update tool description/schemaget_published_tool_details - Get tool details