How mateuszdabrowski/sqlstudio works
SQL Studio is a Marketing Cloud Engagement Cloud Page app for authoring and running SQL within the user's own account. The documented workflow runs from the editor through query execution to paged or exported results; other capabilities include SQL assistance, saved Query Activities, and query history. The README identifies the Cloud Page and two Code Resources but does not expose source excerpts, so internal call ownership and several integration details remain unverified; dashed edges mark those links.
Main entry points: sql-studio-frontend.js Frontend app · sql-studio.html Studio page · sql-studio-backend.html Query execution
Components 16
SQL authoring
- Studio page
src/cloud-page/sql-studio.html - Frontend app
src/code-resources/sql-studio-frontend.js - SQL editor
src/code-resources/sql-studio-frontend.js - SQL assistance
src/code-resources/sql-studio-frontend.js
Query runtime
- Query tabs
src/code-resources/sql-studio-frontend.js - Backend resource
src/code-resources/sql-studio-backend.html - Query execution
src/code-resources/sql-studio-backend.html - Results and export
src/code-resources/sql-studio-frontend.js - Saved queries
src/code-resources/sql-studio-backend.html - Query history
src/code-resources/sql-studio-backend.html
MCE resources
- Marketing Cloud
- Query Activities
- Temporary Data Extension
- DE and system views
Other components
- MCE user
- Monaco CDN
Connections 16
- MCE user → Studio page: opens
README.md - Studio page → Frontend app: loads
- Studio page → Monaco CDN: loads editor
README.md - Frontend app → SQL editor: provides
- SQL editor → SQL assistance: uses
- SQL assistance → DE and system views: autocompletes
README.md - Frontend app → Query tabs: provides
- Query tabs → Backend resource: runs queries
- Backend resource → Query execution: handles runs
- Query execution → Query Activities: uses pool
README.md - Query execution → Temporary Data Extension: writes results
README.md - Temporary Data Extension → Results and export: pages and exports
README.md - Frontend app → Saved queries: saves and opens
- Frontend app → Query history: shows history
- Query Activities → Marketing Cloud: runs in
README.md - Temporary Data Extension → Marketing Cloud: stored in
README.md