calculate_db_capacity_and_config
Estimate row size, table footprint, and B-Tree index memory for millions of rows, then generate tuned PostgreSQL or MySQL configuration parameters for the target hardware.
Instructions
Estimate physical row size, heap/clustered table footprint, and B-Tree index memory requirements for N million rows, and generate tuned postgresql.conf or my.cnf parameters.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"dialect": "<dialect>"
},
"name": "calculate_db_capacity_and_config"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dialect | Yes | ||
| schema_ddl | No | ||
| server_hardware | No | ||
| estimated_rows_per_table | No |