{"description":"Example payloads for each MCP tool - use these as reference when calling tools/call method","examples":{"sql_query":{"description":"Execute raw SQL query","payload":{"method":"tools/call","params":{"name":"sql_query","arguments":{"sql":"SELECT id, name, total FROM transaction WHERE status = 'completed' ORDER BY created_at DESC LIMIT 20"}}},"notes":"Always use 'sql' as field name, should be a valid SQL SELECT query"},"read_schema_context":{"description":"Read database schema and context","payload":{"method":"tools/call","params":{"name":"read_schema_context","arguments":{"full":true,"section":"tables","tableName":"transaction"}}},"notes":"Options: section=['database_context','flows','tables','rules'], tableName optional"},"read_prisma_schema":{"description":"Read Prisma schema definitions","payload":{"method":"tools/call","params":{"name":"read_prisma_schema","arguments":{"full":true,"model":"Transaction"}}},"notes":"model parameter optional, returns Prisma schema"},"generate_report":{"description":"Generate interactive HTML report with charts, tables, KPIs, filters, and optional tabbed views","payload":{"method":"tools/call","params":{"name":"generate_report","arguments":{"title":"Laporan Penjualan Top 5 Produk","description":"Data penjualan minggu ini (7 hari terakhir)","queries":[{"name":"top_products","sql":"SELECT p.name, SUM(ti.quantity) as total_qty, SUM(ti.subtotal) as total_sales FROM transaction_item ti JOIN product p ON ti.product_id = p.id GROUP BY p.id ORDER BY total_sales DESC LIMIT 5"}],"sections":[{"type":"header","title":"Laporan Penjualan Top 5 Produk"},{"type":"table","title":"Top 5 Products by Sales","query":"top_products","columns":[{"key":"name","label":"Product Name","format":"text"},{"key":"total_qty","label":"Quantity","format":"number"},{"key":"total_sales","label":"Sales (IDR)","format":"currency"}]}],"tabs":[{"id":"overview","title":"Overview","sections":[{"type":"kpi","title":"Ringkasan KPI","query":"top_products","config":{"items":[{"label":"Total Qty","key":"total_qty","format":"number"},{"label":"Total Sales","key":"total_sales","format":"currency"}]}}]},{"id":"detail","title":"Detail Produk","sections":[{"type":"table","title":"Detail Penjualan Produk","query":"top_products","columns":[{"key":"name","label":"Product Name","format":"text"},{"key":"total_qty","label":"Quantity","format":"number"},{"key":"total_sales","label":"Sales (IDR)","format":"currency"}]}]}],"uploadToS3":false}}},"notes":"queries: array of {name, sql}, sections: root/global sections, tabs: optional tabbed report pages where each tab has {id,title,description?,sections[]}. Section types: header, filter, kpi, chart, table. Layout control: sections[].config.layout = {colSpan:1-12, colSpanTablet:1-12, colSpanMobile:1-12}. For filterable reports, every KPI/chart/table queryTemplate should include all report filter tokens unless section.config.ignoreFilters=true."},"s3_upload":{"description":"Upload file to S3-compatible storage (Cloudhost)","payload":{"method":"tools/call","params":{"name":"s3_upload","arguments":{"key":"reports/laporan-2026-04-28.html","fileContent":"...","isBase64":false,"contentType":"text/html","acl":"public-read"}}},"notes":"key: file path in S3, fileContent: actual content or base64, acl: public-read|private|public-read-write"},"s3_list":{"description":"List files in S3 bucket","payload":{"method":"tools/call","params":{"name":"s3_list","arguments":{"prefix":"reports/"}}},"notes":"prefix optional, returns list of files in bucket with that prefix"},"s3_delete":{"description":"Delete file from S3","payload":{"method":"tools/call","params":{"name":"s3_delete","arguments":{"key":"reports/old-report.html"}}},"notes":"key is required"},"s3_url":{"description":"Generate public URL for S3 file","payload":{"method":"tools/call","params":{"name":"s3_url","arguments":{"key":"reports/laporan-2026-04-28.html"}}},"notes":"Returns public URL for accessing the file"},"test_connection":{"description":"Test database connection","payload":{"method":"tools/call","params":{"name":"test_connection","arguments":{}}},"notes":"No arguments needed, returns {connected: true/false}"}},"full_mcp_request_example":{"description":"Complete HTTP request example with MCP wrapper","request":{"method":"POST","url":"${baseUrl}/mcp","headers":{"x-api-key":"your-api-key-here","Content-Type":"application/json"},"body":{"jsonrpc":"2.0","id":"1","method":"tools/call","params":{"name":"sql_query","arguments":{"sql":"SELECT COUNT(*) as total_transactions FROM transaction"}}}},"response":{"jsonrpc":"2.0","id":"1","result":{"content":[{"type":"json","data":[{"total_transactions":15420}]}]}}}}