Set up docs MCP| Input | Output | Alias |
|---|---|---|
| ✗ | ✔ |
Description
Differs from the PrettyCompactNoEscapes format in that up to 10,000 rows are buffered,
and then output as a single table, and not by blocks.
Example usage
Format settings
The following settings are common to all Pretty formats:
| Setting | Description | Default |
|---|---|---|
output_format_pretty_max_rows |
Row limit for Pretty formats. | 10000 |
output_format_pretty_max_column_pad_width |
Maximum width to pad all values in a column in Pretty formats. | 250 |
output_format_pretty_max_value_width |
Maximum width of value to display in Pretty formats. If greater - it will be cut. | 10000 |
output_format_pretty_color |
Use ANSI escape sequences to paint colors in Pretty formats. | true |
output_format_pretty_grid_charset |
Charset for printing grid borders. Available charsets: ASCII, UTF-8. | UTF-8 |
output_format_pretty_row_numbers |
Add row numbers before each row for pretty output format. | true |
output_format_pretty_display_footer_column_names |
Display column names in the footer if table contains many rows. | true |
output_format_pretty_display_footer_column_names_min_rows |
Sets the minimum number of rows for which a footer will be displayed if output_format_pretty_display_footer_column_names is enabled. |
50 |