Database Management

Database Admin
MySQL

Database Type

Custom

RLS Type

Disabled

RLS Status

0

Databases

GraphQL

API Enabled

Connection Details

MySQL
default

Row Level Security (RLS)

Custom RLS

About RLS

PostgreSQL: Uses native Row Level Security policies.

MySQL: Uses views, stored functions, and triggers to achieve equivalent security.

PostgreSQL RLS

Native RLS is automatically enabled on tables.

Protected Tables

Table Owner Column Status
users uuid ✓ Protected
profiles user_uuid ✓ Protected
rls_users uuid ✓ Protected

How RLS Works

PostgreSQL
CREATE POLICY ON users USING (auth.uid() = uuid)
MySQL
SELECT * FROM v_rls_users WHERE uuid = get_current_user_uuid()

GraphQL API

Endpoint

POST/GET /graphql

Use GraphQL queries and mutations instead of REST endpoints.

Example Query

query {
  user
  health
}

mutation {
  signup(email: "user@example.com", password: "pass123", name: "John") {
    uuid
    email
  }
}

Testing GraphQL