Six deeply integrated modules that replace a dozen tools. From SQL to realtime, auth to storage — all in one unified platform.
SQL Editor
Schema-aware query builder
Write and execute SQL with intelligent autocomplete, schema browser, query history, and visual explain plans. Export results in CSV, JSON, or Parquet.
SELECT u.id, u.email, COUNT(o.id) orders
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.created_at > NOW() - INTERVAL '30 days'
GROUP BY u.id
ORDER BY orders DESC
LIMIT 20;Authentication
Plug-and-play auth providers
Manage users, sessions, roles, and OAuth providers from a single dashboard. Built-in JWT signing, MFA support, and granular RBAC policies.
// JWT verification middleware
const { user } = await swifton.auth
.verifyToken(request.headers.authorization)
if (!user.roles.includes('admin')) {
throw new UnauthorizedError()
}File Storage
S3-compatible object store
Manage files, images, and documents with bucket-level policies, CDN delivery, automatic image optimization, and signed URLs.
const url = await swifton.storage
.bucket('avatars')
.upload(file, { path: `users/${userId}` })
.transform({ width: 256, format: 'webp' })
.getPublicUrl()Auto-generated APIs
REST & GraphQL in seconds
Your database schema automatically exposes a REST and GraphQL API with filtering, sorting, pagination, and real-time subscriptions — zero boilerplate.
query GetUsers($limit: Int) {
users(limit: $limit, order_by: { created_at: desc }) {
id email name
orders_aggregate { count }
}
}Realtime
Event-driven pub/sub
Subscribe to database changes with Redis-powered pub/sub. Build live dashboards, collaborative apps, and notification systems with zero infrastructure.
const channel = swifton.realtime
.channel('public:orders')
.on('INSERT', ({ new: order }) => {
updateDashboard(order)
})
.subscribe()Project Settings
Full control & observability
Manage team access, API keys, connection strings, usage limits, and compliance settings. Detailed audit logs for every operation.
swifton.admin.roles.create({
name: 'read-only-analyst',
permissions: [
'tables:read', 'queries:execute',
'storage:read'
]
})Enterprise-grade components powering every layer of the stack.
PostgreSQL 16
ACID-compliant relational storage
Redis 7
Caching, sessions & pub/sub
Git-style branching
Branch your database schema
Built-in analytics
Query performance insights
Encryption at rest
AES-256 for all data
Multi-region
Global edge replicas
CLI tooling
swifton-cli for full control
99.99% SLA
Enterprise-grade uptime