Database Client - Query your database without SQL · GPT-Aktionen

{
  "openapi": "3.1.0",
  "info": {
    "title": "Database Query Executor",
    "description": "Executes specified SQL queries on a configured database using encrypted credentials.",
    "version": "v1.0.0"
  },
  "servers": [
    {
      "url": "https://chatssh.net"
    }
  ],
  "paths": {
    "/execute_query.php": {
      "post": {
        "description": "Execute an SQL query on a database using encrypted credentials",
        "operationId": "executeQuery",
        "parameters": [
          {
            "name": "http-api-key",
            "in": "header",
            "required": true,
            "description": "API key for authentication",
            "schema": {
              "type": "string"
            }
          }
        ],
        "requestBody": {
          "description": "Data containing the chatDbToken and the SQL query to be executed",
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "chatDbToken": {
                    "type": "string",
                    "description": "The ChatDbToken used to access encrypted database configuration"
                  },
                  "query": {
                    "type": "string",
                    "description": "The SQL query to be executed on the database"
                  }
                },
                "required": [
                  "chatDbToken",
                  "query"
                ]
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "Query executed successfully on the database",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "result": {
                      "type": "array",
                      "items": {
                        "type": "object"
                      },
                      "description": "Results of the executed SQL query"
                    }
                  }
                }
              }
            }
          },
          "400": {
            "description": "Invalid request or required parameters not provided"
          },
          "401": {
            "description": "Unauthorized access due to invalid or missing API key"
          },
          "500": {
            "description": "Internal Server Error, such as decryption failure or database connection errors"
          }
        },
        "deprecated": false
      }
    }
  },
  "components": {
    "schemas": {}
  }
}