Pi DeepSearch

{
  "conversations": [
    {
      "conversation_id": "01930f4a-...",
      "metadata": {
        "user_id": "alice@example.com",
        "client_id": "100002",
        "chat_title": "Revenue analysis",
        "platform": "on_prem_mysql",
        "last_updated": 1713174600,
        "is_favourite": false
      }
    }
  ],
  "count": 3,
  "user_id": "alice@example.com",
  "client_id": "100002"
}

{
  "conversation_id": "01930f4a-...",
  "metadata": {
    "user_id": "alice@example.com",
    "chat_title": "Revenue analysis",
    "platform": "on_prem_mysql",
    "last_updated": 1713174600
  },
  "messages": [
    {
      "role": "user",
      "content": "What was total revenue last month?"
    },
    {
      "role": "assistant",
      "content": "Total revenue last month was $1,234,567.",
      "has_chart": true,
      "chart_data": {
        "type": "chart_data",
        "chart_data": { "chart_type": "bar", "echarts": { "option": {} } }
      },
      "has_feedback": true,
      "feedback": {
        "reaction": "thumbs_up",
        "feedback_text": null,
        "submitted_at": "2026-04-15T10:30:00.000000+00:00",
        "message_index": 1,
        "submitted_by": "alice@example.com",
        "client_id": "100002"
      }
    }
  ]
}

{
  "conversation_id": "01930f4a-...",
  "conversation_title": "Monthly Revenue Deep Dive",
  "client_id": "100002",
  "status": "success"
}

{
  "success": true,
  "conversation_id": "01930f4a-...",
  "client_id": "100002",
  "message": "Conversation deleted successfully"
}

{
  "conversation_id": "01930f4a-...",
  "is_favourite": true,
  "status": "success"
}

{
  "conversation_id": "01930f4a-...",
  "is_favourite": false,
  "status": "success"
}

{
  "feedback_reaction": "thumbs_up",
  "feedback_text": "Very accurate.",
  "message_index": 1
}

{
  "success": true,
  "message": "Feedback submitted successfully",
  "conversation_id": "01930f4a-...",
  "feedback_id": "01930f4a-...#1#0698639b-...",
  "feedback": {
    "reaction": "thumbs_up",
    "feedback_text": "Very accurate.",
    "submitted_at": "2026-04-15T10:30:00.000000+00:00",
    "message_index": 1,
    "submitted_by": "alice@example.com",
    "client_id": "100002"
  }
}

{
  "platforms": [
    {
      "platformKey": "on_prem_mysql",
      "selectedTables": ["transactions", "merchants"],
      "columns": {
        "transactions": ["id", "amount", "status", "created_at"],
        "merchants": ["id", "name", "mcc_code"]
      },
      "kpis": [
        {
          "name": "Approval Rate",
          "formula": "approved / total",
          "query": "SELECT COUNT(*) FILTER (WHERE status='approved') / COUNT(*)::float FROM transactions"
        }
      ],
      "piiClassification": {
        "transactions.card_number": { "contains_PII": true, "PII_Type": "Credit Card Number" }
      },
      "ssasMetadata": null
    }
  ],
  "budgets": [
    {
      "id": "uuid",
      "name": "Monthly Cap",
      "amount": 50000.00,
      "currency": "USD",
      "period": "monthly"
    }
  ],
  "governance": {},
  "updatedAt": "2026-04-15T10:30:00.000000+00:00"
}

{ "success": true, "message": "Datasource 'on_prem_mysql' removed" }

{
  "host": "db.internal",
  "port": 3306,
  "username": "deepsearch_user",
  "password": "new-password"
}

{ "success": true, "message": "Datasource 'on_prem_mysql' updated" }

{
  "addTables": ["refunds"],
  "removeTables": ["legacy_log"],
  "addColumns": {
    "refunds": ["id", "amount", "reason"]
  },
  "removeColumns": {
    "transactions": ["internal_flag"]
  }
}

{
  "success": true,
  "platform": "on_prem_mysql",
  "schema": {
    "selectedTables": ["transactions", "merchants", "refunds"],
    "columns": {
      "transactions": ["id", "amount", "status"],
      "merchants": ["id", "name"],
      "refunds": ["id", "amount", "reason"]
    }
  }
}

{
  "name": "Decline Rate",
  "formula": "declined / total",
  "query": "SELECT COUNT(*) FILTER (WHERE status='declined') / COUNT(*)::float FROM transactions",
  "description": "Fraction of transactions declined"
}

{
  "success": true,
  "message": "KPI 'Decline Rate' added",
  "kpi": {
    "name": "Decline Rate",
    "formula": "declined / total",
    "query": "SELECT ...",
    "description": "Fraction of transactions declined"
  }
}

{ "query": "SELECT ...", "description": "Updated description" }

{
  "success": true,
  "message": "KPI 'Decline Rate' updated",
  "kpi": { "name": "Decline Rate", "query": "SELECT ...", "description": "Updated description" }
}

{ "success": true, "message": "KPI 'Decline Rate' deleted" }

{
  "name": "Monthly Spend Cap",
  "amount": 50000.00,
  "currency": "USD",
  "period": "monthly"
}

{
  "success": true,
  "message": "Budget added",
  "budget": { "id": "uuid", "name": "Monthly Spend Cap", "amount": 50000.0, "currency": "USD", "period": "monthly" }
}

{
  "success": true,
  "message": "Budget updated",
  "budget": { "id": "uuid", "name": "Monthly Spend Cap", "amount": 60000.0, "currency": "USD", "period": "monthly" }
}

{ "success": true, "message": "Budget deleted" }

{
  "environmentName": "Production",
  "businessEntity": "Acme Corp",
  "environmentType": "production",
  "timeZone": "America/New_York",
  "description": "Main production database"
}

{
  "success": true,
  "message": "Environment information saved successfully",
  "data": {
    "environmentName": "Production",
    "businessEntity": "Acme Corp",
    "environmentType": "production",
    "timeZone": "America/New_York",
    "description": "Main production database"
  }
}

{
  "platform": "on_prem_mysql",
  "host": "db.internal",
  "port": 3306,
  "username": "deepsearch",
  "password": "secret"
}

{
  "success": true,
  "message": "Connection successful",
  "data": { "connectionValidated": true, "testedAt": "2026-04-15T10:30:00Z" }
}

{
  "success": true,
  "message": "Schema details loaded successfully",
  "data": {
    "platform": "azure_sql",
    "schemas": [
      {
        "schema": "PaymentsDB",
        "tables": [
          {
            "tableName": "transactions",
            "rowCount": 5000000,
            "columnCount": 12,
            "primaryKeys": ["id"],
            "foreignKeys": [],
            "hasPII": false
          }
        ]
      }
    ]
  }
}

{ "platform": "on_prem_mysql" }

{
  "success": true,
  "message": "Found 3 dataset(s)",
  "data": { "databases": ["payments", "analytics", "reporting"] }
}

{
  "platform": "on_prem_mysql",
  "database": "payments",
  "snowflakeSchema": null
}

{
  "success": true,
  "message": "Found 8 table(s)",
  "data": {
    "database": "payments",
    "tables": [
      {
        "table": "transactions",
        "fullName": "payments.transactions",
        "schema_name": "payments",
        "rowCount": 5000000,
        "primaryKey": ["id"],
        "columns": [
          { "name": "id", "type": "bigint", "isPrimaryKey": true, "isNullable": false },
          { "name": "amount", "type": "decimal", "isPrimaryKey": false, "isNullable": false }
        ]
      }
    ]
  }
}

{
  "name": "card_number",
  "type": "varchar",
  "contains_PII": true,
  "Confidence_Score": 0.98,
  "PII_Type": "Credit Card Number",
  "Reasoning": "Column name 'card_number' strongly indicates payment card data."
}

{
  "platform": "on_prem_mysql",
  "tableDetails": [
    {
      "tableName": "transactions",
      "columns": ["id", "amount", "status", "created_at"]
    }
  ]
}

{
  "domains": [
    {
      "domain": "Transaction Performance",
      "kpis": [
        {
          "name": "Approval Rate",
          "description": "Percentage of transactions approved",
          "formula": "approved_count / total_count",
          "query": "SELECT COUNT(*) FILTER (WHERE status='approved') / COUNT(*)::float AS approval_rate FROM transactions"
        }
      ]
    }
  ]
}

{
  "original_kpi": {
    "name": "Approval Rate",
    "formula": "approved / total",
    "query": "SELECT ..."
  },
  "instruction": {
    "query": "Break this down by merchant category",
    "selected_columns": ["transactions.mcc_code", "transactions.status", "transactions.id"]
  }
}

{
  "platformKey": "on_prem_mysql",
  "selectedTables": ["transactions", "merchants"],
  "selectedColumns": {
    "transactions": ["id", "amount", "status", "created_at"],
    "merchants": ["id", "name", "mcc_code"]
  },
  "piiClassification": {
    "transactions.pan": { "contains_PII": true, "PII_Type": "Credit Card Number" }
  },
  "kpis": [
    {
      "name": "Approval Rate",
      "formula": "approved / total",
      "query": "SELECT COUNT(*) FILTER (WHERE status='approved') / COUNT(*)::float FROM transactions"
    }
  ],
  "budgets": [],
  "governance": {},
  "ssasMetadata": null
}

{
  "success": true,
  "platformKey": "on_prem_mysql",
  "updatedAt": "2026-04-15T10:30:00.000000+00:00"
}

{
  "nodes": [
    {
      "id": "users",
      "type": "tableNode",
      "position": { "x": 50, "y": 200 },
      "data": {
        "label": "users",
        "columns": [
          { "name": "id", "type": "UUID", "pk": true, "fk": null, "nullable": false },
          { "name": "email", "type": "VARCHAR(255)", "pk": false, "fk": null, "nullable": false }
        ]
      }
    }
  ],
  "edges": [
    {
      "id": "e1",
      "source": "orders",
      "target": "users",
      "sourceHandle": "user_id",
      "targetHandle": "id",
      "type": "smoothstep",
      "animated": false,
      "label": "user_id → users.id",
      "markerEnd": { "type": "ArrowClosed" }
    }
  ]
}

{
  "selectedTables": [
    {
      "table": "transactions",
      "fullName": "payments.transactions",
      "db_schema": "payments",
      "primaryKey": ["id"],
      "columns": [
        { "name": "id", "type": "bigint" },
        { "name": "merchant_id", "type": "bigint" }
      ]
    },
    {
      "table": "merchants",
      "fullName": "payments.merchants",
      "db_schema": "payments",
      "primaryKey": ["id"],
      "columns": [
        { "name": "id", "type": "bigint" },
        { "name": "name", "type": "varchar" }
      ]
    }
  ]
}

{
  "flow": {
    "nodes": [ { "id": "transactions", "type": "tableNode", "position": { "x": 60, "y": 60 }, "data": { "label": "transactions", "columns": [] } } ],
    "edges": [ { "id": "e0", "source": "transactions", "target": "merchants", "sourceHandle": "merchant_id", "targetHandle": "id", "type": "smoothstep", "label": "many-to-one" } ]
  },
  "relationships": [
    {
      "from_table": "transactions",
      "from_column": "merchant_id",
      "to_table": "merchants",
      "to_column": "id",
      "type": "many-to-one"
    }
  ],
  "views": []
}

{
  "metrics": [
    {
      "metric_key": "approval_rate",
      "display_name": "Approval Rate",
      "description": "Fraction of transactions that were approved",
      "unit": "ratio"
    },
    {
      "metric_key": "variance_to_average",
      "display_name": "Variance to Average",
      "description": "Statistical variance of daily approval-rate outcomes from their within-day mean",
      "unit": "ratio"
    }
  ]
}

{ "detail": "Unknown metric_key 'xyz'. Available: approval_rate, variance_to_average." }

{ "metric_key": "approval_rate", "opted_in": false, "data_points": [] }

{
  "mcc_code": "6012",
  "industry_category": "FINTECH",
  "opted_into_benchmark": true
}

{ "detail": "Invalid industry_category 'GAMING'. Must be one of: FINTECH, ECOMMERCE, ..." }

{
  "status": "healthy",
  "version": "1.4.2",
  "model": "claude-sonnet-4-6",
  "active_ws": 3,
  "connections": [
    {
      "user_email": "alice@example.com",
      "client_id": "100002",
      "platform": "on_prem_mysql",
      "conversation_id": "01930f4a-...",
      "idle_seconds": 12,
      "duration_seconds": 145
    }
  ],
  "redis":     { "status": "connected", "latency_ms": 1 },
  "postgres":  { "status": "connected", "latency_ms": 4 },
  "dynamodb":  { "status": "connected", "latency_ms": 18 },
  "anthropic": { "status": "reachable", "latency_ms": 42 }
}