🏥 Rxchange MCP Server

OAuth 2.1 Resource Server with MS Entra ID (via OAuth Proxy)

🔐 OAuth Endpoints

• Protected Resource Metadata
• Authorization Server Metadata
• POST /oauth/register - Dynamic Client Registration
• GET /oauth/authorize - Authorization Endpoint
• POST /oauth/token - Token Endpoint

🤖 MCP Endpoint

• POST /mcp - MCP endpoint (Bearer token required) Auth Required

📊 Data API

REST API for Excel, Power BI, and external tools. Use API key or OAuth token.

• GET /api/data/schema - Database schema
• GET /api/data/queries - List saved queries
• GET /api/data/queries/{id} - Execute query (OData params supported)
• GET /api/data/queries/{id}/export?format=xlsx - Export to Excel/CSV
• GET /api/data/odata/queries/{id} - OData endpoint for Power BI

📈 Charts API

• GET /api/charts/{id} - Interactive chart (HTML)
• GET /api/charts/{id}/config - Chart.js configuration
• GET /api/charts/{id}/data - Chart data (JSON)
• GET /api/charts/{id}/export?format=csv - Export chart data

🎯 Dashboards API NEW

• GET /api/dashboards/{id} - Interactive dashboard (HTML)
• GET /api/dashboards/{id}/data/{source} - Dashboard data source
• GET /api/dashboards/{id}/metadata - Dashboard metadata
• GET /api/dashboards - List dashboards Auth

🔧 MCP Tools Available

Database Connections

• list_database_connections - List configured DB connections
• add_database_connection - Add new SQL Server connection
• test_database_connection - Test connection
• remove_database_connection - Remove connection

Schema Exploration

• get_database_schema - Complete DB schema with relationships
• get_table_schema - Table details with sample values
• get_table_relationships - Foreign key relationships

Dynamic Queries

• create_query_definition - Create virtual view from JSON
• validate_query_definition - Validate without executing
• execute_query - Run saved query
• list_saved_queries - List user's queries
• delete_query - Delete saved query

Raw SQL Advanced

• execute_raw_sql - Execute raw SQL (CTEs, window functions, PIVOT)
• validate_raw_sql - Validate raw SQL without executing

Data Export

• export_to_excel - Export to XLSX
• export_to_csv - Export to CSV
• get_data_api_url - Get URL for Excel/Power BI
• create_api_key - Create API key for external tools
• list_api_keys - List API keys
• revoke_api_key - Revoke API key

Charts

• create_chart - Create interactive chart
• list_charts - List user's charts
• get_chart_url - Get chart URLs
• refresh_chart_data - Refresh chart data
• delete_chart - Delete chart

Dashboards

• create_dashboard - Create dashboard with HTML/JS
• update_dashboard - Update dashboard content
• list_dashboards - List user's dashboards
• get_dashboard_url - Get dashboard URL
• delete_dashboard - Delete dashboard

Dynamic Tool Publishing NEW

• publish_query_as_tool - Publish a query as a standalone MCP tool
• unpublish_tool - Remove a published tool
• list_published_tools - List your published tools
• update_published_tool - Update tool description/schema
• get_published_tool_details - Get tool details