# OpenSheets / PlatPhorm Sheets
> Read-only spreadsheet viewer and tabular intelligence layer for PlatPhormNews.

Base URL: https://sheets.platphormnews.com
Version: 0.1.0-phase1
Server-indexed sheets: 0
Server-indexed rows: 0
Persistence: degraded (No DATABASE_URL is configured. Server APIs expose public read-only empty state; browser imports are saved as explicit local previews.)

## Purpose
Sheets lets humans and agents ingest, view, search, filter, summarize, export, share, cite, and analyze tabular data 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
- sheets: https://sheets.platphormnews.com/api/v1/sheets
- sheet: https://sheets.platphormnews.com/api/v1/sheets/{id}
- 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
- 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
- exportCsv: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/csv
- exportPdf: https://sheets.platphormnews.com/api/v1/sheets/{id}/export/pdf
- share: https://sheets.platphormnews.com/api/v1/sheets/{id}/share
- health: https://sheets.platphormnews.com/api/health
- docs: https://sheets.platphormnews.com/api/docs
- openapi: https://sheets.platphormnews.com/openapi.yaml
- mcp: https://sheets.platphormnews.com/api/mcp

## MCP
- Tools: list_sheets, get_sheet, search_sheets, search_rows, ingest_sheet_from_url, ingest_sheet_from_paste, get_sheet_rows, get_sheet_columns, get_sheet_summary, get_categories, filter_sheet, export_sheet_csv, export_sheet_pdf, create_share_view, get_share_view, analyze_sheet, compare_sheets, find_trends, create_docs_report, create_deck_summary
- Resources: opensheets://sheets, opensheets://sheets/{id}, opensheets://sheets/{id}/rows, opensheets://sheets/{id}/summary, opensheets://categories, opensheets://share/{id}, opensheets://openapi, opensheets://llms, opensheets://trust-policy
- Prompts: analyze_sheet, compare_sheets, find_trends, summarize_sheet, generate_table_report, explain_data_quality, create_sheet_handoff

## Trust Policy
Web spreadsheet browsing, public-safe sheet search, browser-based sheet preview, local non-sensitive sheet draft persistence, trusted-domain discovery, standard route compliance, Vercel metadata capture, trace-linked sheet ingestion, and MCP spreadsheet discovery are intentionally supported for public read-only and operator workflows. Mutating, administrative, protected sheet ingestion, private export, publishing, sync, test-triggering, reporting, and write actions require PLATPHORM_API_KEY.