greptimedb-table-design
GreptimeDB Table Design
Help the user design a table schema for performance, or improve an existing one. The schema is the most impactful performance decision in GreptimeDB. This skill has two entry points — a new table (every lever is open) and an existing table (most key decisions are baked in at creation; only some things can be altered).
For server-level config (caches, write buffer, WAL) see greptimedb-performance-tuning. To
diagnose why a query/write is slow before redesigning, see greptimedb-performance-diagnosis.
Ask up front: is this a new table or an existing one? and the GreptimeDB version.
To run the SQL in this guide (CREATE TABLE, ALTER TABLE, SHOW CREATE TABLE,
INSERT ... SELECT), use any of: the greptimedb-mcp-server execute_sql tool if available;
a MySQL or PostgreSQL client; the built-in
GreptimeDB Dashboard;
or (Enterprise) the Management Console.