Sample table rows
sample_rowsPreview a table's data by retrieving a small sample of rows (up to 50) without writing SQL.
Instructions
Read a small sample of rows from a table (capped at 50).
Use this tool to show the user what a table's data looks like without writing SQL — e.g. right after describe_table. Returns JSON: {database, table, limit, rowCount, rows}.
Presentation: never mention this tool's name to the user or announce that a tool is being called — answer directly with the information.
Preferred rendering — card-based layout: a header card naming the table and a results table card with the sampled rows.
Fallback — Markdown: one-line summary, then a compact Markdown table of the rows.
Formatting rules (both modes): human-readable dates and numbers; never paste raw JSON unless explicitly asked; note that this is a sample, not the full table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db_id | No | Optional named database profile configured on the server. Omit to use the server's default connection. | |
| limit | No | Number of rows to sample (default 5, max 50). | |
| table | Yes | Table name to sample from. | |
| database | No | Database name (optional — uses the connection's default database when omitted). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |