Project Management
Create and manage multiple API projects. Track versions, manage team access, and organize your backends in one centralized platform.
Product & Platform Features
SWAIN is a comprehensive visual platform that generates production-ready APIs from your database. Manage projects, build queries visually, and deploy backends — all without writing code.
Trial provides complete platform access; the Playground requires no account to experiment with queries.
Platform Features
Visual Query Builder
Drag-and-drop interface for building complex queries. Real-time validation, testing against your data, and automatic JSON generation.
Team Collaboration
Invite team members, set permissions, share projects. Built-in role management for developers, managers, and stakeholders.
Schema Explorer
Interactive visualization of your database structure. Browse tables, view relationships, and select what to include in your API.
One-Click Generation
Generate complete API packages instantly. Download deployable backends with all configurations, ready for your infrastructure.
Regeneration‑Based Versions
Track schema changes and regenerate APIs as your database evolves. Manage versions via environments/branches; no built-in concurrent version manager.
Generated API Features
Zero‑Boilerplate CRUD
Auto‑generated endpoints: GET /api/{model}, GET /api/{model}/{id}, POST, PUT, DELETE, and bulk filter endpoints.
Multi‑Database Support
PostgreSQL, MySQL, SQLite. MongoDB support is experimental (basic CRUD only) while full NoSQL parity is in progress.
Automatic Schema Discovery
Introspect tables, columns, foreign keys — relationships are detected and folded into your API automatically.
Rich Querying & Filtering
JSON-based filters with AND/OR/NOT, comparisons, wildcards, nested relation filters, and aggregates.
Pagination & Sorting
Consistent page, pageSize, and sort across list endpoints.
Relationship Handling
Include related entities using relationship expressions with "include": true in JSON filters; avoid N+1 with smart joins behind the scenes.
Real‑Time Updates
WebSockets with model‑specific channels (created/updated/deleted), permission‑filtered streams.
Authentication & Security
JWT & API keys; Row‑Level Security (RLS) to enforce tenant isolation and fine‑grained access rules.
OpenAPI Docs
Interactive Swagger/OpenAPI served with schema details, field types, and example requests.
Visual Configuration Tools
Configure auth, RLS, CORS, rate limits, and deployment options through intuitive UI.
Security Configuration
Set up authentication providers, define RLS rules, and configure permissions — all through intuitive visual forms.
API Settings Manager
Configure CORS, rate limiting, pagination defaults, and endpoint behaviors through the platform interface.
Database Connection Manager
Securely connect to any PostgreSQL, MySQL, SQLite, or MongoDB database with encrypted credential storage.
Deployment Helper
Ships with a production-ready Dockerfile. Compose/Kubernetes manifests are not included but can be created to fit your infrastructure.