tidb · Capability

TiDB HTTP API — Statistics

TiDB HTTP API — Statistics. 1 operations. Lead operation: Dump table statistics. Self-contained Naftiko capability covering one Tidb business surface.

Run with Naftiko TidbStatistics

What You Can Do

GET
Dumptablestats — Dump table statistics
/v1/stats/dump/{db}/{table}

MCP Tools

dump-table-statistics

Dump table statistics

read-only idempotent

Capability Spec

http-statistics.yaml Raw ↑
naftiko: 1.0.0-alpha2
info:
  label: TiDB HTTP API — Statistics
  description: 'TiDB HTTP API — Statistics. 1 operations. Lead operation: Dump table statistics. Self-contained Naftiko capability
    covering one Tidb business surface.'
  tags:
  - Tidb
  - Statistics
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    TIDB_API_KEY: TIDB_API_KEY
capability:
  consumes:
  - type: http
    namespace: http-statistics
    baseUri: http://localhost:10080
    description: TiDB HTTP API — Statistics business capability. Self-contained, no shared references.
    resources:
    - name: stats-dump-db-table
      path: /stats/dump/{db}/{table}
      operations:
      - name: dumptablestats
        method: GET
        description: Dump table statistics
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: timestamp
          in: query
          type: integer
          description: Optional Unix timestamp to retrieve historical statistics at a specific point in time.
  exposes:
  - type: rest
    namespace: http-statistics-rest
    port: 8080
    description: REST adapter for TiDB HTTP API — Statistics. One Spectral-compliant resource per consumed operation, prefixed
      with /v1.
    resources:
    - path: /v1/stats/dump/{db}/{table}
      name: stats-dump-db-table
      description: REST surface for stats-dump-db-table.
      operations:
      - method: GET
        name: dumptablestats
        description: Dump table statistics
        call: http-statistics.dumptablestats
        with:
          timestamp: rest.timestamp
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: http-statistics-mcp
    port: 9090
    transport: http
    description: MCP adapter for TiDB HTTP API — Statistics. One tool per consumed operation, routed inline through this capability's
      consumes block.
    tools:
    - name: dump-table-statistics
      description: Dump table statistics
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: http-statistics.dumptablestats
      with:
        timestamp: tools.timestamp
      outputParameters:
      - type: object
        mapping: $.