# DataViews.pro — SFMC Schema Architect

> An advanced optimizer and sandbox for visualizing and generating SQL against Salesforce Marketing Cloud (SFMC) Data Views.

## Summary

- **Product**: DataViews.pro (SFMC Schema Architect)
- **Purpose**: Interactive schema registry, relationship explorer, and SQL generator for SFMC system Data Views
- **Architect**: Ujjwal Tiwari — Senior Salesforce Platform Architect, Waterloo, Ontario, Canada
- **Website**: https://ujjwaltiwari.com
- **Scope**: 29 core SFMC marketing data views including _Subscribers, _Job, _Sent, _Open, _Click, _Bounce, _Journey, and Mobile Push views
- **Status**: Public Beta Release

## Full documentation

For complete platform details, feature list, data view index, and attribution, see:
https://dataviews.pro/llms-full.txt

## Key capabilities

- Browse and search all SFMC Data View schemas with field types and descriptions
- Visual join-path discovery with BFS routing across related tables
- SQL Sandbox with auto-generated JOINs, bridge tables, and copy-to-clipboard output
- AI Copilot assistance for query design and schema exploration

## Attribution

Engineered with Gemini and Cursor AI. Schemas grounded on official Salesforce Documentation, Mateusz Dąbrowski's SFMC technical blog, and structural benchmarks from dataviews.io.