{"name":"opensheets","version":"0.3.0-phase3","protocol":"JSON-RPC 2.0","description":"OpenSheets MCP server for read-only spreadsheet discovery, search, filtering, summaries, export metadata, and honest degraded ingest/report actions.","endpoint":"https://sheets.platphormnews.com/api/mcp","tools":[{"name":"get_sheets_info","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"list_workbooks","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_workbook","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"list_sheets","description":"List server-indexed public sheets and persistence status.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"get_sheet","description":"Get metadata and rows for a server-indexed sheet by id.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"search_sheets","description":"Search server-indexed sheet metadata.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"search_rows","description":"Search rows in a server-indexed sheet.","inputSchema":{"type":"object","properties":{}}},{"name":"get_sheet_rows","description":"Read rows from a server-indexed sheet.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"get_sheet_columns","description":"Read columns from a server-indexed sheet.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"get_sheet_summary","description":"Return computed summary for a server-indexed sheet.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"get_data_quality","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"detect_schema","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"detect_duplicates","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"profile_columns","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_categories","description":"List real server categories.","inputSchema":{"type":"object","properties":{}}},{"name":"filter_sheet","description":"Filter rows in a server-indexed sheet.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"group_by_sheet","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"pivot_sheet","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"aggregate_sheet","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"preview_join","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"lookup_rows","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"find_unmatched_rows","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"query_sheet","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"explain_query","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"validate_rows","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_validation_results","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_sheet_lineage","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"list_sheet_snapshots","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"compare_sheet_snapshots","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"get_row_provenance","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_cell_provenance","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_column_provenance","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"create_share_view","description":"Create a durable share view when persistence exists.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"get_share_view","description":"Read a durable share view.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"create_report_pack","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_report_pack","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"create_dashboard_from_sheet","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"get_dashboard","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"analyze_sheet","description":"Analyze a server-indexed sheet.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"compare_sheets","description":"Compare server-indexed sheets.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"find_trends","description":"Find trends in a server-indexed sheet.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"summarize_sheet","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"generate_table_report","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"preview_ingest_from_url","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"url":{"type":"string"},"title":{"type":"string"}},"required":["url"]}},{"name":"validate_tabular_source","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_ingestion_status","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_integration_status","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_route_compliance","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_discovery_compliance","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_agent_policy","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"list_agent_platforms","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_public_access_summary","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_health","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"get_info","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"export_sheet_csv","description":"Export a server-indexed sheet as CSV.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"export_sheet_json","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"export_sheet_markdown","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"export_sheet_pdf","description":"Report PDF export status.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"ingest_sheet_from_paste","description":"Protected real parser for pasted CSV/TSV text; returns a non-persistent preview.","inputSchema":{"type":"object","properties":{"text":{"type":"string"},"title":{"type":"string"}},"required":["text"]}},{"name":"ingest_sheet_from_url","description":"Protected URL ingest with SSRF controls; degraded until durable persistence is wired.","inputSchema":{"type":"object","properties":{"url":{"type":"string"},"title":{"type":"string"}},"required":["url"]}},{"name":"persist_sheet","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"delete_sheet","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{"id":{"type":"string"},"query":{"type":"string"},"limit":{"type":"number"}}}},{"name":"create_computed_column","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"create_pivot_view","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"create_join_view","description":"OpenSheets tool.","inputSchema":{"type":"object","properties":{}}},{"name":"create_docs_report","description":"Protected Docs report integration; degraded until wired.","inputSchema":{"type":"object","properties":{}}},{"name":"create_deck_summary","description":"Protected Decks summary integration; degraded until wired.","inputSchema":{"type":"object","properties":{}}}],"resources":[{"uri":"opensheets://workbooks","name":"workbooks","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://workbook/{id}","name":"workbook/{id}","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://sheets","name":"sheets","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://sheets/{id}","name":"sheets/{id}","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://sheets/{id}/rows","name":"sheets/{id}/rows","description":"Rows for a server-indexed sheet.","mimeType":"application/json"},{"uri":"opensheets://sheets/{id}/columns","name":"sheets/{id}/columns","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://sheets/{id}/summary","name":"sheets/{id}/summary","description":"Summary for a server-indexed sheet.","mimeType":"application/json"},{"uri":"opensheets://sheets/{id}/quality","name":"sheets/{id}/quality","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://sheets/{id}/lineage","name":"sheets/{id}/lineage","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://sheets/{id}/provenance","name":"sheets/{id}/provenance","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://categories","name":"categories","description":"Real server categories.","mimeType":"application/json"},{"uri":"opensheets://share/{id}","name":"share/{id}","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://ingestion-runs","name":"ingestion-runs","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://jobs","name":"jobs","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://reports","name":"reports","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://report-packs","name":"report-packs","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://dashboards","name":"dashboards","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://integrations","name":"integrations","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"opensheets://openapi","name":"openapi","description":"OpenAPI discovery.","mimeType":"text/plain"},{"uri":"opensheets://llms","name":"llms","description":"LLM-readable discovery.","mimeType":"text/plain"},{"uri":"opensheets://trust-policy","name":"trust-policy","description":"OpenSheets trust policy.","mimeType":"text/plain"},{"uri":"agent-policy://summary","name":"agent-policy://summary","description":"Summary for a server-indexed sheet.","mimeType":"application/json"},{"uri":"agent-policy://platforms","name":"agent-policy://platforms","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"agent-policy://robots","name":"agent-policy://robots","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"agent-policy://ai-policy","name":"agent-policy://ai-policy","description":"OpenSheets resource.","mimeType":"application/json"},{"uri":"agent-policy://trust-policy","name":"agent-policy://trust-policy","description":"OpenSheets trust policy.","mimeType":"text/plain"}],"prompts":[{"name":"analyze_sheet","description":"analyze sheet","arguments":[{"name":"sheet_id","required":true}]},{"name":"compare_sheets","description":"compare sheets","arguments":[{"name":"sheet_id","required":false}]},{"name":"find_trends","description":"find trends","arguments":[{"name":"sheet_id","required":true}]},{"name":"summarize_sheet","description":"summarize sheet","arguments":[{"name":"sheet_id","required":true}]},{"name":"generate_table_report","description":"generate table report","arguments":[{"name":"sheet_id","required":true}]},{"name":"explain_data_quality","description":"explain data quality","arguments":[{"name":"sheet_id","required":true}]},{"name":"create_sheet_handoff","description":"create sheet handoff","arguments":[{"name":"sheet_id","required":true}]},{"name":"create_report_matrix","description":"create report matrix","arguments":[{"name":"sheet_id","required":true}]},{"name":"create_docs_report_from_sheet","description":"create docs report from sheet","arguments":[{"name":"sheet_id","required":true}]},{"name":"create_pivot_plan","description":"create pivot plan","arguments":[{"name":"sheet_id","required":true}]},{"name":"create_join_plan","description":"create join plan","arguments":[{"name":"sheet_id","required":true}]},{"name":"create_dashboard_plan","description":"create dashboard plan","arguments":[{"name":"sheet_id","required":true}]},{"name":"explain_sheet_lineage","description":"explain sheet lineage","arguments":[{"name":"sheet_id","required":true}]},{"name":"human_machine_sheets_handoff","description":"human machine sheets handoff","arguments":[{"name":"sheet_id","required":true}]}],"auth":{"public":["initialize","ping","tools/list","resources/list","resources/read","prompts/list","prompts/get"],"protected":["ingest_sheet_from_url","ingest_sheet_from_paste","create_docs_report","create_deck_summary"],"platformKey":"PLATPHORM_API_KEY"},"persistence":{"mode":"degraded","available":false,"status":"degraded","databaseUrlConfigured":false,"adapter":"none","message":"No DATABASE_URL is configured. Server APIs expose public read-only empty state; browser imports are saved as explicit local previews."}}