Visual Platform · No Code Required · Multi‑DB Support

Generate production APIs through our visual platform

SWAIN is a comprehensive visual platform that transforms your PostgreSQL, MySQL, SQLite, or MongoDB database into a complete REST API. Connect your database, configure through our intuitive interface, and deploy a production-ready backend — all without writing code.

Start Free Trial — full platform Try Playground — no sign‑up

Choose what fits: Trial unlocks the entire platform; Playground lets you explore queries instantly without creating an account.

Visual Query Builder Project Management Team Collaboration One-Click Generation

cURL · Example

curl -H "Authorization: Bearer <JWT>" \
  "https://api.your-domain.com/api/user?page=1&pageSize=25&sort=name:asc"

Why SWAIN?

A complete visual platform for API generation. Create projects, connect databases, build queries, and generate production-ready backends — all through an intuitive web interface, no coding required.

Visual Platform

No-Code API Generation

Complete web platform with project management, Visual Query Builder, and One-Click Generation. Configure everything through intuitive forms and drag-and-drop tools.

Flexible

Rich Filtering & Relationships

JSON filter language with AND/OR/NOT, comparisons, wildcards, and relationship filters — GraphQL‑like expressiveness over REST.

Secure

Authentication & RLS

JWT & API key auth, multi‑tenant isolation via Row‑Level Security, and permission hooks enforced before queries hit the DB.

Realtime

WebSockets

Model‑specific channels (e.g., /ws/user/created) and filtered subscriptions for building reactive dashboards.

Docs

Swagger/OpenAPI

Interactive API docs generated with schemas, types, and example requests so teams can integrate fast.

Multi‑DB

Postgres, MySQL, SQLite

Switch SQL engines with a config change; MongoDB support is available as experimental (basic CRUD).

How it works

Create a project in the platform.
Connect your database securely.
Configure using visual tools and forms.
Test queries with the Query Builder.
Generate & download your API package.
Deploy to your infrastructure.

See the workflow Security model

JavaScript · Fetch

const res = await fetch('https://api.your-domain.com/api/orders/filter?page=1&pageSize=20&sort=created_at:desc', {
  method: 'POST',
  headers: {
    'Content-Type': 'application/json',
    'Authorization': `Bearer ${'{'}token{'}'}`
  },
  body: JSON.stringify({
    expressions: [
      { field: 'status', operator: 'eq', value: 'active' },
      {
        relationship: 'customer',
        include: true,
        expressions: [
          { field: 'region', operator: 'in', value: ['EU','US'] }
        ]
      }
    ]
  })
});

Filter DSL · Quick Reference

{
  "expressions": [
    { "field": "status", "operator": "eq", "value": "active" },
    {
      "operator": "OR",
      "expressions": [
        { "field": "age", "operator": "lt", "value": 25 },
        { "field": "age", "operator": "gt", "value": 50 }
      ]
    },
    {
      "relationship": "customer",
      "include": true,
      "expressions": [
        { "field": "region", "operator": "in", "value": ["EU", "US"] }
      ]
    }
  ]
}

Tip: pass pagination as query params (e.g., ?page=1&pageSize=20&sort=name:asc).

Use cases

Rapid Prototyping

Turn ideas into working APIs on day one. Regenerate as your schema evolves and keep moving.

Front‑End Teams

Ship full‑stack apps without writing a backend. Query with JSON; build features faster.

Internal Tools

Expose secure endpoints for dashboards and analytics — with permissions enforced automatically.

Explore stories

Transparent pricing

Simple plans for teams of any size. All prices in USD. Save 17% with annual billing (2 months free).

Monthly Yearly Save 17% • 2 months free

Security first

JWT & API key auth, RLS for tenant isolation, and query‑time enforcement across every endpoint.

Read the security overview

Starter

USD $0 /mo

Up to 3 models
REST CRUD & filtering
OpenAPI docs

Start Free Trial

Pro

USD $29 /mo

Unlimited models
Auth (JWT/API keys)
Row‑Level Security iRow-Level Security restricts which rows each user can access based on policies tied to identity (e.g., tenant ID). Helps enforce tenant isolation and least privilege.
WebSockets

Start Free Trial

Enterprise

Custom

SAML/SCIM iSAML provides Single Sign-On with your identity provider; SCIM automates user provisioning and deprovisioning. Ideal for enterprise user management.
VPC & on‑prem
Dedicated support
SLAs

Talk to sales

From database to API — faster than ever

Focus on your unique logic and user experience. SWAIN handles the rest.

Try Playground — no sign‑up