🛢️ Database & Schema
Connect MongoDB, PostgreSQL, and Oracle databases to your Sniffer project, pull schema snapshots, surface PII fields, and link schema objects to bugs.
🌟 Overview#
Sniffer’s Database module lets you attach real database schemas to your project so that bugs, code, and data are linked. When the AI analyzes a bug involving a SQL query, a 500 from a backend API, or a slow page, it can reference the actual schema — column types, indexes, PII tags, row counts — to give better fix suggestions.
Supports:
- 🟢 MongoDB
- 🐘 PostgreSQL
- 🟠 Oracle
🖼️ Insert image of the Databases page with several connected DBs listed.
Routes:
- Database list →
/sf/projects/:id/databases - Schema viewer →
/sf/projects/:id/databases/:alias/schema
➕ Connecting a Database#
- Navigate to Databases from the project sidebar.
- Click + Connect Database.
- Fill in the form:
Why a “Connection Ref” instead of password fields? Credentials are stored centrally in 🏢 Company Settings → SecretManager so the same DB can be reused across multiple projects without re-entering secrets.
- Click Test Connection to verify.
- Click Save — the DB appears in the list.
📋 Database List#
🔍 Schema Viewer#
Click View Schema on any DB to open the Schema Viewer (/sf/projects/:id/databases/:alias/schema).
Top-Level Summary#
A summary header shows:
Health Indicators#
Sniffer flags common schema issues:
- 🔵 Only-PK index — table has only a primary-key index (may be under-indexed)
- 🟡 Over-indexed — too many indexes (write penalty)
- ⚪ No fields — empty schema
- ⚫ Empty objects — zero rows
- 🟣 Un-masked PII — PII field without auto-blur rule
Object Browser#
A tree on the left lists every object (table, view, materialized view, collection):
- Type icon next to the name
- Approximate row count
- ⚡ Expand to see fields
Click an object to load the detail pane on the right.
🖼️ Insert image of the Schema Viewer with the object tree on the left and the detail pane on the right.
Object Detail Pane#
🔐 PII Detection#
When schema is discovered, Sniffer automatically tags fields that look like PII:
email,phone,ssn,dob,address,name,credit_card,passport, …- Heuristics from field name + data-sample inspection
- Manually-tagged via the PII config in 🏢 Company Settings → PII Management
Fields tagged as PII automatically:
- Get a ⛔ chip in the schema viewer
- Are added to the auto-blur list for screenshots/recordings
- Get masked in network log capture
- Trigger compliance alerts if accessed by un-authorized roles
🖼️ Insert image of a Schema Viewer table with PII fields highlighted.
🔁 Refreshing Snapshots#
Snapshots are pulled on-demand and cached:
- Click Refresh to re-pull the schema immediately
- Schedule periodic snapshots from project settings (daily / weekly)
- Version history is kept — compare two snapshots to see drift
🔗 Linking Bugs to Schema Objects#
When creating or editing a bug, you can link affected database objects:
- Open the 🐛 Bug Details drawer
- Scroll to Database Objects section
- Click + Link Object and pick from a searchable list
- The bug now shows the affected schema in the 🐛 Bug Details drawer and is queryable in the 📊 Dashboard “Hot Tables” widget
🤖 AI Schema-Awareness#
When an external AI assistant connected via 🤖 MCP Integration analyzes a bug with a linked DB object, it can:
- Suggest indexes for slow queries
- Identify columns missing in a SELECT
- Recommend joins
- Flag potential PII leaks in API responses
- Propose migrations
🔐 Permissions#
🐞 Troubleshooting#
See ❓ Troubleshooting → Database Schema Not Pulling .