# MySQLBot

> MySQLBot produces verified, cited **research briefs**, **competitor analyses**, and **structured data extracted from documents**, fulfilled by a self-hosted LLM behind a draft → web-verify pipeline. It exposes a plain HTTPS + JSON API designed for autonomous AI agents: create an order, poll its status, and fetch the finished result inline — no browser required.

Notes for agents:
- **Self-provision, no human:** `POST ?action=register` (no auth) mints your own prepaid `sk_` key with a zero balance and returns a `top_up_url`. A human funds it once; the key then spends its balance per order automatically.
- Authenticate with an API key in the `X-Api-Key: sk_...` header on every request.
- Order lifecycle: `create_order` → poll `status` → `deliverable` (returned inline as markdown / CSV / JSON). Check credit with `action=balance`; a low balance returns `402 insufficient_balance` + a `top_up_url`.
- **Full account/team management** (parity with the web control panel) is available to a key on a team account: `account`, `list_members`, `invite_member`, `remove_member`, `set_permissions`, `list_keys`, `create_key`, `revoke_key`, `rename_account`, `set_display_name`, `set_password`, `list_orders` — each gated by the key member's permissions.
- Responses are a uniform envelope: `{ "ok": <bool>, "error": "<code>", "data": { ... } }`. Errors carry a machine-readable `error` code and matching HTTP status.
- Fulfilment is asynchronous (a brief takes a few minutes; extraction is faster). Poll every 15–30s.

## API
- [API guide (for AI agents & developers)](https://mysqlbot.com/pages/public/serviceApiGuide.php): Complete usage guide — base URL, auth, the create→status→deliverable flow, every field, limits, error table, and curl examples.
- [OpenAPI specification](https://mysqlbot.com/openapi.json): Machine-readable OpenAPI 3.0 description of the endpoints and schemas.
- [API endpoint](https://mysqlbot.com/pages/public/serviceApi.php): The JSON API itself. Send `X-Api-Key`; a request with no key returns `401 invalid_api_key`.

## Get access
- [Client sign-in / sign-up](https://mysqlbot.com/pages/public/client/login.php): Create an account, then generate an API key under **Team → Create key** (shown once).
- [Order a service (human web form)](https://mysqlbot.com/pages/public/?page=services): The same services via the website.

## About
- [Home](https://mysqlbot.com/pages/public/)
- [Contact](https://mysqlbot.com/pages/public/?page=contact)

## Optional
- [Terms of use](https://mysqlbot.com/pages/public/?page=tofu)
- [Privacy policy](https://mysqlbot.com/pages/public/?page=cookies)