Baasix MCP Server

Get all available collections/schemas in Baasix with optional search and pagination

Get detailed schema information for a specific collection

Create a new collection schema in Baasix. FIELD TYPES: - String: VARCHAR with values.length (e.g., 255) - Text: Unlimited text - Integer, BigInt: Whole numbers - Decimal: values.precision & values.scale - Float, Real, Double: Floating point - Boolean: true/false - Date, DateTime, Time: Date/time - …

Update an existing collection schema

Delete a collection schema

Add an index to a collection schema

Remove an index from a collection schema

Create a relationship between collections. RELATIONSHIP TYPES: - M2O (Many-to-One): Creates foreign key with auto-index. products.category → categories - O2M (One-to-Many): Virtual reverse of M2O. categories.products → products - O2O (One-to-One): Creates foreign key with auto-index. user.profile →…

Update an existing relationship

Delete a relationship

Export all schemas as JSON

Import schemas from JSON data

Query items from a collection with powerful filtering, sorting, pagination, relations, and aggregation. FILTER OPERATORS (50+): - Comparison: eq, neq, gt, gte, lt, lte - String: contains, icontains, startswith, endswith, like, ilike, regex - Null: isNull (true/false), empty (true/false) - List: in,…

Get a specific item by ID from a collection, optionally including related data

Create a new item in a collection

Update an existing item in a collection

Delete an item from a collection

List files with metadata and optional filtering

Get detailed information about a specific file

Delete a file

Check the current authentication status and token validity

Force refresh the authentication token (only works for email/password auth)

Generate reports with grouping and aggregation for a collection

Get collection statistics and analytics

List notifications for the authenticated user

Send a notification to specified users

Mark a notification as seen

Get application settings

Update application settings

List all email templates with optional filtering

Get a specific email template by ID

Update an email template's subject, description, or body content. TEMPLATE TYPES: - magic_link: Magic link authentication emails - invite: User invitation emails - password_reset: Password reset emails - welcome: Welcome emails - verification: Email verification emails AVAILABLE VARIABLES: - User:…

List all available roles

List all permissions with optional filtering

Get a specific permission by ID

Get permissions for a specific role

Create a new permission for role-based access control. ACTIONS: create, read, update, delete FIELDS: - ["*"] for all fields - ["name", "price"] for specific fields CONDITIONS (Row-level security): - Uses same filter operators as queries - {"published": {"eq": true}} - only published records - {"a…

Update an existing permission

Delete a permission

Reload the permission cache

Update permissions for a role

Get the status of the realtime service including WAL configuration. Returns information about: - Whether realtime is initialized and consuming WAL - PostgreSQL replication configuration (wal_level, max_replication_slots) - Publication and replication slot status - Collections with realtime enabled

Check PostgreSQL replication configuration for WAL-based realtime. Returns: - walLevel: Should be 'logical' for realtime to work - maxReplicationSlots: Number of available replication slots - maxWalSenders: Number of WAL sender processes - replicationSlotExists: Whether the baasix slot exists - pub…

Get list of collections with realtime enabled and their action configurations

Enable realtime for a collection. Changes will be broadcast via WebSocket when data is modified. The realtime config is stored in the schema definition and can include specific actions to broadcast.

Disable realtime for a collection

Get Baasix server information and health status

Sort items within a collection (move item before/after another)

Register a new user

Login user with email and password

Send an invitation to a user

Verify an invitation token

Send magic link or code for authentication

Get available tenants for the current user

Switch to a different tenant context

Logout the current user

Get current user information with role and permissions