Developer Reference

REST API Reference v1

Automate PostgreSQL database provisioning, SQL execution, credential rotation, and storage telemetry.

https://mqzz.site/api/v1/

Authorization: Bearer mqzz_live_...

Authentication Endpoints

POST /auth/register

Body: { "full_name": "Jane Dev", "username": "janedev", "email": "jane@example.com", "password": "SecretPassword123!" }

POST /auth/login

Authenticate with username/email and receive an API Bearer token.

Body: { "login": "janedev", "password": "SecretPassword123!" }

GET /auth/me

Returns authenticated user profile and live storage quota breakdown.

GET /databases

List all active PostgreSQL databases owned by the authenticated account.

POST /databases

Provision a brand new isolated PostgreSQL database and restricted role.

Body: { "name": "production_api" }

GET /databases/{id}/credentials

Retrieve decrypted database credentials, connection URI, and port parameters.

POST /databases/{id}/reset-password

Instantly rotate database role password inside PostgreSQL and return new credentials.

POST /databases/{id}/suspend POST /databases/{id}/resume

Revoke or restore remote CONNECT privileges on the target database.

DELETE /databases/{id}

Terminate connections and execute `DROP DATABASE` and `DROP ROLE`.

POST /databases/{id}/query

Execute a SQL query via HTTP. Enforces strict 10s statement timeouts and connects using isolated role.

Body: { "query": "SELECT * FROM users WHERE active = true LIMIT 50;" }

GET /databases/{id}/tables

List all tables and types defined within the user's schemas.

GET /api-keys POST /api-keys

List active API keys or generate a new secret token for CI/CD integration.

GET /usage/storage

Fetch physical disk bytes used across each database via `pg_database_size()`.