agent
  1. Tables
agent
  • Authentication
  • Logs
    • Get Log
      GET
    • Clear Logs
      POST
  • Database
    • Tables
      • Create Table
        POST
      • Delete Table
        DELETE
    • Create Database
      POST
    • Delete Database
      DELETE
    • Get Databases
      GET
  • User
    • Create User
      POST
    • Delete User
      DELETE
  • System
    • Get System Info
      GET
    • Run System Action
      POST
    • Install Database
      POST
    • Is Database Installed
      GET
  • Schema
    • Create Schema
      POST
    • Delete Schema
      DELETE
    • Get Schemas
      GET
  1. Tables

Create Table

Developing
POST
/database/table/create
Maintainer:Not configured

Request

Authorization
Provide your bearer token in the
Authorization
header when making requests to protected resources.
Example:
Authorization: Bearer ********************
Body Params application/json

Examples

Responses

🟢200OK
application/json
Body

Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request POST 'http://10.11.53.2:2885/api/v1-alpha/database/table/create' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data-raw '{
  "database": "shop",
  "schema": "public",
  "table": {
    "name": "users",
    "columns": [
      {
        "name": "id",
        "type": "INTEGER",
        "flags": {
          "primary": true,
          "unique": true,
          "nullable": false,
          "default": null,
          "autoIncrement": true,
          "index": true,
          "unsigned": true,
		  "length": 5
        },
        "foreignKeys": [],
        "constraints": []
      },
	  {
        "name": "first_name",
        "type": "TEXT",
        "flags": {
          "primary": false,
          "unique": false,
          "nullable": false,
          "default": null,
          "autoIncrement": false,
          "index": true,
          "unsigned": false,
		  "length": 20
        },
        "foreignKeys": [],
        "constraints": []
      },
	  {
        "name": "age",
        "type": "INTEGER",
        "flags": {
          "primary": false,
          "unique": false,
          "nullable": false,
          "default": null,
          "autoIncrement": false,
          "index": true,
          "unsigned": false,
		  "length": 3
        },
        "foreignKeys": [],
        "constraints": []
      },
	  {
        "name": "initials",
        "type": "VARCHAR",
        "flags": {
          "primary": false,
          "unique": false,
          "nullable": false,
          "default": null,
          "autoIncrement": false,
          "index": true,
          "unsigned": false,
		  "length": 3
        },
        "foreignKeys": [],
        "constraints": []
      }
    ],
    "indexes": [
      {
        "name": "",
        "columns": [],
        "unique": false
      }
    ],
    "constraints": {
      "primary_keys": [],
      "uniques": [],
      "checks": [],
      "foreign_keys": []
    },
    "options": {
      "engine": "InnoDB",
      "charset": "utf8mb4",
      "collation": "utf8mb4_unicode_ci",
      "comment": "Benutzertabelle",
      "if_not_exists": true
    }
  }
}'
Response Response Example
{}
Modified at 2025-08-03 18:05:30
Previous
Clear Logs
Next
Delete Table
Built with