Will It Vibe logoWill It Vibe?
SQL-017Low severity-4 points

View defined with SELECT *

Part of Code Quality & Syntax, which counts for 20% of the overall score. When this check fires it deducts 4 points from that category, once per scan, no matter how many places it turns up.

What it detects

A view built on SELECT * changes shape silently whenever the underlying table gains, loses, or reorders columns, which can break every consumer of the view or quietly expose a newly added column to everyone who can query it.

Why it matters

A view built on SELECT * changes shape whenever the underlying table's columns change: adding a column to the base table silently adds it to every consumer of the view (which can leak a newly added sensitive column to whoever has access to the view), and reordering or renaming columns can break anything that reads the view by position instead of by name.

How to fix it

List the specific columns the view needs to expose instead of *. This makes the view's contract explicit, so a future column added to the base table does not automatically flow through to every consumer without a deliberate decision.

The paid report includes a ready-to-paste prompt for your AI coding agent for every check it finds, pointed at the exact findings from your scan. See pricing

Does your repo trip this check?

Paste a GitHub URL or drop a project folder. Scans run in your browser and take seconds.

Scan your repo

Related Code Quality & Syntax checks