Row-level security that makes sense

Set permissions in plain English. "Any member can create," "members can update their own," "anyone can read." No SQL policies to debug.

Built for relationships

Connect records across tables. Link posts to authors, comments to posts, members to favorites. It's a real relational database.

Prisma-like queries

Filter, sort, paginate, and include relationships with a query syntax developers already know. Cursor-based pagination included.

Field types you need

Text, numbers, decimals, booleans, dates, references, emails, and URLs. Unique constraints and required fields supported.

Member references built-in

Connect any record to members automatically. Track who created what, build favorites lists, manage permissions by ownership.

Proper API rate limits

200 requests per 30 seconds globally. Separate limits for reads, creates, and writes. Built to scale.

Frequently Asked Questions

Will my existing Memberstack auth work with Data Tables?

Yes. Data Tables plugs into your existing Memberstack setup. Same auth, same members, same dashboard.

Can non-members create records?

Yes, if you set the create rule to "public." Otherwise, only authenticated members can create records.

What are the rate limits?

200 requests per 30 seconds globally. For Data Tables specifically: 25 reads per second, 10 creates per minute, and 30 writes per minute. All limits are per IP address.

Does this work with Webflow?

Yes. Access it through window.$memberstackDom in your Webflow project. Same methods as the standard DOM package.

How is this different from Supabase or Firebase?

Memberstack combines auth and database in one tool. Row-level security is configured visually instead of writing policies. It's designed for builders who want simplicity without sacrificing power.

Can I export my data?

Yes. You can query all your records through the API and export them. We recommend regular backups during beta.

What happens to my data if Data Tables shuts down?

We'll give you advance notice and migration tools if we ever discontinue the feature. Your Memberstack account and auth data are separate and unaffected.

Can I connect records to members automatically?

Yes. Every record tracks which member created it. You can also create member reference fields to build features like favorites, follows, or ownership.

Does this support many-to-many relationships?

Yes. Use REFERENCE_MANY for record-to-record relationships and MEMBER_REFERENCE_MANY for member relationships. Query them with includes and pagination.

Is there a cost for Data Tables?

Pricing isn't finalized while we're in beta. We'll announce pricing before the stable release. Beta users will get advance notice of any changes.

How many records can I store?

No hard limit announced yet. During beta, build what you need. We'll share capacity limits before the stable release.

Can I query by custom fields?

Yes. Use the where clause to filter by any field. Supports equals, contains, greater than, less than, AND, OR, and NOT operators.

Does this replace my existing backend?

For many apps, yes. If you need auth, user data, and a relational database, Data Tables covers it. You might still need a backend for complex business logic or third-party integrations.

Can I use this with Next.js or React?

Yes. Install @memberstack/dom and use it in any JavaScript environment. Works client-side and server-side.

What about file uploads?

Not supported yet. Use URL fields to reference files hosted elsewhere (Cloudinary, S3, etc.).

Can I run raw SQL queries?

No. You use our query API, which is based on Prisma syntax. This keeps your data secure and maintainable.

How do I handle pagination?

Use cursor-based pagination with take and after. The response includes endCursor for the next page. Supports up to 100 records per request.

What's the difference between REFERENCE and MEMBER_REFERENCE fields?

REFERENCE links to other records in your tables. MEMBER_REFERENCE links to Memberstack members (users). Both support one-to-one and one-to-many relationships.