dbaas.dev

{
  "name": "dbaas.dev",
  "description": "PostgreSQL agent that plans and executes multi-step database workflows from a single natural-language request. Just send text — the agent decides which steps to run internally (provision, schema design, sample data, stored procedures, migrations, ORM codegen, data Q&A). No skill selection required. Direct skill access also available for deterministic/programmatic use. A2A v0.2 JSON-RPC: POST /a2a tasks/send → 202 + Task object, tasks/get for result. Legacy flat shape: POST /a2a/tasks/send {id,message} also accepted.",
  "url": "https://api.dbaas.dev/a2a",
  "version": "2.4.0",
  "documentationUrl": "https://dbaas.dev/integrations/a2a",
  "capabilities": {
    "streaming": false,
    "pushNotifications": false,
    "stateTransitionHistory": true,
    "async": true,
    "taskPolling": true
  },
  "authentication": {
    "schemes": [
      "Bearer"
    ],
    "required": false,
    "description": "Optional Authorization: Bearer <32-128 char client_token>. When supplied, task and any provisioned databases are bound to the token (only callers presenting it can poll/use). Equivalent: X-Client-Token header or metadata.client_token in body."
  },
  "defaultInputModes": [
    "application/json",
    "text/plain"
  ],
  "defaultOutputModes": [
    "application/json"
  ],
  "skills": [
    {
      "id": "workflow",
      "name": "Natural Language Workflow",
      "description": "DEFAULT INTERFACE — send any database goal as plain text. The agent plans and executes all required steps internally: provision, schema design, sample data, stored procedures, schema migrations, ORM codegen, data Q&A. No skill selection or sequencing needed from the caller. Single submit → poll → full result. Optional: pass metadata.database_id to operate on an existing DB instead of provisioning a new one — workflow will introspect its current schema and plan migrations/queries accordingly.",
      "tags": [
        "workflow",
        "ai",
        "agent",
        "natural-language",
        "default"
      ],
      "examples": [
        "create a blog database with users, posts, and comments — seed 10 rows and generate TypeScript types",
        "set up an e-commerce DB, add sample products and orders, then tell me the average order value",
        "create a credit scoring schema, add a stored procedure that calculates scores, and export the data",
        "build a SaaS analytics DB, migrate the schema to add a status column, then generate Prisma models",
        "(with database_id=...) add a deleted_at column to users and an index on email",
        "(with database_id=...) tell me the top 5 customers by order value"
      ],
      "category": "workflow",
      "inputSchema": {
        "properties": {
          "database_id": {
            "description": "Optional: existing ephemeral database ID. When provided, the workflow skips provisioning and runs all steps against this database. Caller must have ownership (matching client_token or originating IP).",
            "type": "string"
          },
          "text": {
            "description": "Free-form natural language database request — primary input.",
            "type": "string"
          }
        },
        "type": "object"
      },
      "primary": true
    },
    {
      "id": "provision-postgres",
      "name": "Provision Ephemeral PostgreSQL",
      "description": "Spin up an ephemeral Postgres 18 database with a TTL of 1–60 minutes. Result contains connection_string.",
      "tags": [
        "database",
        "postgres",
        "ephemeral",
        "provision"
      ],
      "examples": [
        "provision a postgres database for 60 minutes",
        "give me a throwaway test database"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "ttl_minutes": {
            "default": 60,
            "maximum": 60,
            "minimum": 1,
            "type": "integer"
          }
        },
        "type": "object"
      }
    },
    {
      "id": "get-status",
      "name": "Get Database Status",
      "description": "Returns current status, remaining TTL, and connection_string of an ephemeral database.",
      "tags": [
        "lifecycle",
        "status"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          }
        },
        "required": [
          "database_id"
        ],
        "type": "object"
      }
    },
    {
      "id": "list-my-dbs",
      "name": "List My Databases",
      "description": "Lists all active ephemeral databases owned by the caller (token-bound or IP-bound).",
      "tags": [
        "lifecycle",
        "discovery"
      ],
      "category": "direct-access",
      "inputSchema": {
        "type": "object"
      }
    },
    {
      "id": "extend-ttl",
      "name": "Extend Database TTL",
      "description": "Bumps the expiration of an ephemeral DB by N minutes. Total lifetime cap is configurable (default 90 minutes).",
      "tags": [
        "lifecycle",
        "ttl"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "additional_minutes": {
            "default": 5,
            "maximum": 10,
            "minimum": 1,
            "type": "integer"
          },
          "database_id": {
            "type": "string"
          }
        },
        "required": [
          "database_id"
        ],
        "type": "object"
      }
    },
    {
      "id": "delete-db",
      "name": "Delete Database",
      "description": "Tears down an ephemeral database immediately. Frees the per-IP slot.",
      "tags": [
        "lifecycle",
        "cleanup"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          }
        },
        "required": [
          "database_id"
        ],
        "type": "object"
      }
    },
    {
      "id": "exec-sql",
      "name": "Execute SQL",
      "description": "Execute SQL directly on an ephemeral database. COPY and dangerous system functions are blocked.",
      "tags": [
        "sql",
        "query",
        "direct"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "sql": {
            "type": "string"
          }
        },
        "required": [
          "database_id",
          "sql"
        ],
        "type": "object"
      }
    },
    {
      "id": "generate-query",
      "name": "Generate SQL from Description",
      "description": "NL → SQL. Set execute=true to run it and include rows in the response.",
      "tags": [
        "sql",
        "ai",
        "codegen"
      ],
      "examples": [
        "find the top 5 users by total order value in the last 30 days"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "execute": {
            "default": false,
            "type": "boolean"
          },
          "request": {
            "type": "string"
          }
        },
        "required": [
          "database_id",
          "request"
        ],
        "type": "object"
      }
    },
    {
      "id": "chat-with-data",
      "name": "Chat With Data",
      "description": "NL question → SELECT → execute (read-only) → plain-English answer with rows.",
      "tags": [
        "sql",
        "ai",
        "analytics"
      ],
      "examples": [
        "what is the average order value per customer?",
        "how many users signed up this week?"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "question": {
            "type": "string"
          }
        },
        "required": [
          "database_id",
          "question"
        ],
        "type": "object"
      }
    },
    {
      "id": "describe-schema",
      "name": "Describe Schema",
      "description": "Returns full schema: tables, columns, types, indexes, foreign keys — readable text and structured JSON.",
      "tags": [
        "schema",
        "introspect",
        "metadata"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          }
        },
        "required": [
          "database_id"
        ],
        "type": "object"
      }
    },
    {
      "id": "create-schema",
      "name": "Create Schema from Description",
      "description": "Generate and apply a complete PostgreSQL schema (tables, indexes, FKs) from a natural language description.",
      "tags": [
        "schema",
        "ddl",
        "ai"
      ],
      "examples": [
        "create a schema for an e-commerce platform with users, products, and orders"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "description": {
            "type": "string"
          }
        },
        "required": [
          "database_id",
          "description"
        ],
        "type": "object"
      }
    },
    {
      "id": "migrate-schema",
      "name": "Apply Schema Migration",
      "description": "Generate and apply incremental DDL (ALTER/ADD/DROP) from a natural-language change request.",
      "tags": [
        "schema",
        "migration",
        "ddl",
        "ai"
      ],
      "examples": [
        "add a status column to orders with values pending, paid, shipped"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "description": {
            "type": "string"
          }
        },
        "required": [
          "database_id",
          "description"
        ],
        "type": "object"
      }
    },
    {
      "id": "reset-schema",
      "name": "Reset Schema (Drop All)",
      "description": "DROPs every table in the public schema (CASCADE). Destructive — requires confirm=true.",
      "tags": [
        "schema",
        "destructive"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "confirm": {
            "description": "Must be true to drop tables.",
            "type": "boolean"
          },
          "database_id": {
            "type": "string"
          }
        },
        "required": [
          "database_id",
          "confirm"
        ],
        "type": "object"
      }
    },
    {
      "id": "load-sample-data",
      "name": "Load Sample Data",
      "description": "Generate and insert realistic sample data. Auto-introspects tables, respects FK order.",
      "tags": [
        "data",
        "seed",
        "ai"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "description": {
            "description": "Optional context for data realism.",
            "type": "string"
          },
          "rows": {
            "default": 10,
            "maximum": 100,
            "minimum": 1,
            "type": "integer"
          }
        },
        "required": [
          "database_id"
        ],
        "type": "object"
      }
    },
    {
      "id": "export-data",
      "name": "Export Data",
      "description": "Returns rows from one or all tables as JSON. Capped at max_rows_per_table (default 100, max 1000).",
      "tags": [
        "data",
        "export"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "max_rows_per_table": {
            "default": 100,
            "maximum": 1000,
            "minimum": 1,
            "type": "integer"
          },
          "table": {
            "description": "Optional — export only this table.",
            "type": "string"
          }
        },
        "required": [
          "database_id"
        ],
        "type": "object"
      }
    },
    {
      "id": "add-procedure",
      "name": "Add Stored Procedure",
      "description": "Generate and install a PL/pgSQL function from a natural language description. Auto-introspects schema.",
      "tags": [
        "procedure",
        "plpgsql",
        "ai"
      ],
      "examples": [
        "add a stored procedure that calculates a user's total order value"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "description": {
            "type": "string"
          }
        },
        "required": [
          "database_id",
          "description"
        ],
        "type": "object"
      }
    },
    {
      "id": "generate-orm-models",
      "name": "Generate ORM/Type Models",
      "description": "Schema → typed model code. Supported: typescript, python (Pydantic), sqlalchemy, prisma, go, rust.",
      "tags": [
        "codegen",
        "orm",
        "ai"
      ],
      "examples": [
        "generate TypeScript types for my schema",
        "export Pydantic models for FastAPI"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "database_id": {
            "type": "string"
          },
          "language": {
            "default": "typescript",
            "enum": [
              "typescript",
              "python",
              "sqlalchemy",
              "prisma",
              "go",
              "rust"
            ],
            "type": "string"
          }
        },
        "required": [
          "database_id"
        ],
        "type": "object"
      }
    },
    {
      "id": "provision-database",
      "name": "Provision Ephemeral Database",
      "description": "Spin up a throwaway database of the chosen engine (postgres, valkey, qdrant) with a TTL of 1–60 minutes. Result contains connection_string (plus api_key for Qdrant). SQL skills work on PostgreSQL databases only.",
      "tags": [
        "database",
        "ephemeral",
        "provision"
      ],
      "examples": [
        "give me a throwaway qdrant database for 30 minutes"
      ],
      "category": "direct-access",
      "inputSchema": {
        "properties": {
          "engine": {
            "enum": [
              "postgres",
              "valkey",
              "qdrant"
            ],
            "type": "string"
          },
          "ttl_minutes": {
            "default": 60,
            "maximum": 60,
            "minimum": 1,
            "type": "integer"
          }
        },
        "required": [
          "engine"
        ],
        "type": "object"
      }
    }
  ],
  "protocolVersion": "0.2"
}