SQL for CMS

About SQL for CMS

SQL for CMS brings database-level power to your Framer CMS. Write real SQL queries to search, filter, and manipulate your content — right inside the Framer editor.

 WHAT IT DOES

 Your CMS collections become SQL tables. Your fields become columns. Type a query, hit run, and get instant results.

 FREE FEATURES

— SELECT queries with WHERE, ORDER BY, LIMIT, OFFSET, GROUP BY, HAVING

— JOIN across collections using reference fields

— Aggregate functions: COUNT, SUM, AVG, MIN, MAX

— String matching with LIKE, UPPER, LOWER, TRIM

— Schema browser showing all collections, fields, and types

— Export query results to CSV

— Full light and dark mode support

 PRO FEATURES (paid)

— INSERT new items into any collection

— UPDATE items in bulk with WHERE clauses

— DELETE items with confirmation dialog

— 7-day free trial, no credit card required

 WHO IT'S FOR

 Agencies managing client sites with hundreds of CMS items. Template creators populating demo content. Anyone running a blog, directory, or marketplace on Framer who's tired of clicking through items one by one.

 EXAMPLE QUERIES

 

Find your top-performing posts:

SELECT Title, Views FROM Blog_Posts WHERE Status = 'Published' ORDER BY Views DESC LIMIT 10

 

Bulk-update a field:

UPDATE Blog_Posts SET Featured = true WHERE Views > 5000

 

Join posts with authors:

SELECT p.Title, a.Name FROM Blog_Posts p JOIN Authors a ON p.Author = a.Slug

 

HOW IT WORKS

 1. Install the plugin and open it in any Framer project

2. The schema browser loads all your collections and fields automatically

3. Write SQL in the editor, press Run, and see results instantly

 

All queries run locally in your browser. Your CMS data never leaves the Framer editor. The only external call is license key validation.

 

PRICING

 

Free: Unlimited SELECT queries forever

Pro Monthly: $12/month (7-day free trial)

Pro Lifetime: $99 one-time

1-Month Pass: $19 one-time