standards-explorer-mcp

# Bridge2AI Standards Explorer MCP A Model Context Protocol (MCP) server for the Bridge2AI Standards Explorer that provides tools to search and query standards data from the Synapse platform using SQL. ## Overview This MCP server provides programmatic access to the Bridge2AI Standards Explorer table (`syn63096833`) on Synapse, enabling LLM applications to query and retrieve standards information through the Synapse Table Query API. The server uses FastMCP and implements Synapse's async query pattern with automatic polling. ## Features - **SQL-Based Table Queries**: Execute SQL queries directly against the Bridge2AI Standards Explorer tables - **Text Search**: Convenient search tool for finding text across multiple columns - **Async Job Handling**: Automatically handles Synapse's async query pattern with polling - **Pagination Support**: Control the number of results and offset for paginated queries - **Table Information**: Get metadata about the Bridge2AI Standards Explorer tables and project ## Tools ### `query_table` Execute SQL queries directly against the Bridge2AI Standards Explorer tables. **Parameters:** - `sql_query` (str, required): SQL query string to execute (e.g., `"SELECT * FROM syn63096833 WHERE name LIKE '%FHIR%' LIMIT 10"`) - `max_wait_seconds` (int, optional): Maximum time to wait for query results (default: 30) **Returns:** A dictionary containing: - `success`: Boolean indicating if the query was successful - `sql_query`: The executed SQL query - `row_count`: Number of rows returned - `total_rows`: Total number of matching rows - `columns`: Array of column definitions with names and types - `rows`: Array of result rows with their data **Example queries:** ```sql -- Simple query SELECT * FROM syn63096833 LIMIT 10 -- Search for FHIR standards SELECT * FROM syn63096833 WHERE Standard LIKE '%FHIR%' -- Search across multiple columns SELECT id, Standard, ShortDescription FROM syn63096833 WHERE ShortDescription LIKE '%metadata%' LIMIT 5 …