# OpenSheets / PlatPhorm Sheets
> Canonical public-safe tabular intelligence and workbook/report matrix layer for PlatPhormNews.

Base URL: https://sheets.platphormnews.com
Version: 0.3.0-phase3
Server-indexed sheets: 46
Server-indexed rows: 1625
Persistence: available (AWS Aurora PostgreSQL is configured for protected workbook and sheet persistence.)

## Purpose
Sheets turns tabular data into searchable, filterable, analyzable, exportable, agent-readable, trace-linked knowledge without mutating source spreadsheets.

## Public Access
- Homepage, browse/search UI, local browser sheet previews, discovery files, health summaries, and read-only MCP introspection.

## Protected Access
- Mutating, administrative, protected ingest, private export, network sync, test-triggering, and report generation require PLATPHORM_API_KEY.
- Accepted headers: Authorization: Bearer $PLATPHORM_API_KEY or X-PlatPhorm-API-Key: $PLATPHORM_API_KEY.

## Key Endpoints
- workbooks: https://sheets.platphormnews.com/api/v1/workbooks
- workbook: https://sheets.platphormnews.com/api/v1/workbooks/{id}
- workbookSheets: https://sheets.platphormnews.com/api/v1/workbooks/{id}/sheets
- sheets: https://sheets.platphormnews.com/api/v1/sheets
- sheet: https://sheets.platphormnews.com/api/v1/sheets/{id}
- sheetConfirm: https://sheets.platphormnews.com/api/v1/sheets/{id}/confirm
- rows: https://sheets.platphormnews.com/api/v1/sheets/{id}/rows
- columns: https://sheets.platphormnews.com/api/v1/sheets/{id}/columns
- summary: https://sheets.platphormnews.com/api/v1/sheets/{id}/summary
- charts: https://sheets.platphormnews.com/api/v1/sheets/{id}/charts
- quality: https://sheets.platphormnews.com/api/v1/sheets/{id}/quality
- schema: https://sheets.platphormnews.com/api/v1/sheets/{id}/schema
- duplicates: https://sheets.platphormnews.com/api/v1/sheets/{id}/duplicates
- lineage: https://sheets.platphormnews.com/api/v1/sheets/{id}/lineage
- provenance: https://sheets.platphormnews.com/api/v1/sheets/{id}/provenance
- search: https://sheets.platphormnews.com/api/v1/search
- ingestPaste: https://sheets.platphormnews.com/api/v1/ingest/paste
- ingestUrl: https://sheets.platphormnews.com/api/v1/ingest/url
- ingestUpload: https://sheets.platphormnews.com/api/v1/ingest/upload
- ingestJson: https://sheets.platphormnews.com/api/v1/ingest/json
- ingestMarkdown: https://sheets.platphormnews.com/api/v1/ingest/markdown
- queryPreview: https://sheets.platphormnews.com/api/v1/query/preview
- groupBy: https://sheets.platphormnews.com/api/v1/group-by
- pivot: https://sheets.platphormnews.com/api/v1/pivot-summary
- joinPreview: https://sheets.platphormnews.com/api/v1/join/preview
- computedPreview: https://sheets.platphormnews.com/api/v1/sheets/{id}/computed-columns/preview
- exportCsv: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/csv
- export: https://sheets.platphormnews.com/api/v1/sheets/{id}/export?format=csv|tsv|json|jsonl|xml|txt|html|md
- exportJson: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/json
- exportMarkdown: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/markdown
- exportPdf: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/pdf
- share: https://sheets.platphormnews.com/api/v1/sheets/{id}/share
- dashboards: https://sheets.platphormnews.com/api/v1/dashboards
- reportPacks: https://sheets.platphormnews.com/api/v1/report-packs
- integrations: https://sheets.platphormnews.com/api/v1/integrations
- webStatus: https://sheets.platphormnews.com/web/status
- webStatusApi: https://sheets.platphormnews.com/api/web/status
- webManifest: https://sheets.platphormnews.com/api/web/manifest
- webScorecard: https://sheets.platphormnews.com/api/web/scorecard
- webFingerprints: https://sheets.platphormnews.com/api/web/fingerprints
- health: https://sheets.platphormnews.com/api/health
- docs: https://sheets.platphormnews.com/api/docs
- openapi: https://sheets.platphormnews.com/openapi.yaml
- openapiJson: https://sheets.platphormnews.com/openapi.json
- mcp: https://sheets.platphormnews.com/api/mcp

## MCP
- Tools:
  - get_sheets_info
  - list_workbooks
  - get_workbook
  - list_sheets
  - get_sheet
  - confirm_sheet
  - search_sheets
  - search_rows
  - get_sheet_rows
  - get_sheet_columns
  - get_sheet_summary
  - get_data_quality
  - detect_schema
  - detect_duplicates
  - profile_columns
  - get_categories
  - filter_sheet
  - group_by_sheet
  - pivot_sheet
  - aggregate_sheet
  - preview_join
  - lookup_rows
  - find_unmatched_rows
  - query_sheet
  - explain_query
  - validate_rows
  - get_validation_results
  - get_sheet_lineage
  - list_sheet_snapshots
  - compare_sheet_snapshots
  - get_row_provenance
  - get_cell_provenance
  - get_column_provenance
  - create_share_view
  - get_share_view
  - create_report_pack
  - get_report_pack
  - create_dashboard_from_sheet
  - get_dashboard
  - analyze_sheet
  - compare_sheets
  - find_trends
  - summarize_sheet
  - generate_table_report
  - preview_ingest_from_url
  - validate_tabular_source
  - get_ingestion_status
  - get_integration_status
  - get_route_compliance
  - get_discovery_compliance
  - get_agent_policy
  - list_agent_platforms
  - get_public_access_summary
  - get_health
  - get_info
  - export_sheet_csv
  - export_sheet_json
  - export_sheet_jsonl
  - export_sheet_xml
  - export_sheet_txt
  - export_sheet_html
  - export_sheet_markdown
  - export_sheet_pdf
  - ingest_sheet_from_paste
  - ingest_sheet_from_url
  - persist_sheet
  - delete_sheet
  - create_computed_column
  - create_pivot_view
  - create_join_view
  - create_docs_report
  - create_deck_summary
- Resources:
  - opensheets://workbooks
  - opensheets://workbook/{id}
  - opensheets://sheets
  - opensheets://sheets/{id}
  - opensheets://sheets/{id}/confirm
  - opensheets://sheets/{id}/rows
  - opensheets://sheets/{id}/columns
  - opensheets://sheets/{id}/summary
  - opensheets://sheets/{id}/quality
  - opensheets://sheets/{id}/lineage
  - opensheets://sheets/{id}/provenance
  - opensheets://categories
  - opensheets://share/{id}
  - opensheets://ingestion-runs
  - opensheets://jobs
  - opensheets://reports
  - opensheets://report-packs
  - opensheets://dashboards
  - opensheets://integrations
  - opensheets://web-status
  - opensheets://openapi
  - opensheets://llms
  - opensheets://trust-policy
  - agent-policy://summary
  - agent-policy://platforms
  - agent-policy://robots
  - agent-policy://ai-policy
  - agent-policy://trust-policy
- Prompts:
  - analyze_sheet
  - compare_sheets
  - find_trends
  - summarize_sheet
  - generate_table_report
  - explain_data_quality
  - create_sheet_handoff
  - fix_missing_sheet_artifact
  - create_report_matrix
  - create_docs_report_from_sheet
  - create_pivot_plan
  - create_join_plan
  - create_dashboard_plan
  - explain_sheet_lineage
  - human_machine_sheets_handoff

## Trust Policy
Web dashboard, public-safe discovery, browser-based operations, trusted-domain discovery, standard route
compliance, Vercel metadata capture, trace inspection, and agentic workflow discovery are intentionally
supported for public read-only debugging and operator workflows. Mutating, administrative, ingestion, replay,
fork, remediation, deployment, sync, test-triggering, reporting, and write actions require PLATPHORM_API_KEY.