data_schema
Describe one table of a database on one of your servers: its columns with type, whether they can be empty, default value and primary key. Call it before writing a query against a table you have not seen. Works for postgres, mysql, mariadb and sqlite.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | Server id (or exact name) from hosts_list | |
| table | Yes | Table name, optionally with its schema (e.g. users or public.users) | |
| engine | No | Database engine on that server (default postgres) | |
| database | No | Database name (for sqlite: the .db file path) | |
| username | No | SSH login user (defaults to the server's user, else root) |