# SQL object impact analysis

> SQL object impact analysis is an open-source agent skill for databases. Before modifying a table, column, stored procedure, view, or trigger in a legacy codebase, trace every place that references it — across oth. It is available on Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose.

- **Kind:** Skill
- **Pricing:** Open source
- **Platforms:** Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- **Website:** https://github.com/github/awesome-copilot/tree/main/skills/sql-object-impact-analysis
- **Repository:** https://github.com/github/awesome-copilot
- **GitHub stars:** 41,254
- **License:** MIT
- **Skill name:** sql-object-impact-analysis
- **Collection:** https://github.com/github/awesome-copilot
- **Categories:** databases
- **Listing updated:** 2026-11-17

## About

Before modifying a table, column, stored procedure, view, or trigger in a legacy codebase, trace every place that references it — across other SQL objects (procs, views, triggers) AND application code (C#, Angular/TypeScript, JS, or any language in the repo) — and produce a structured blast-radius report so you know what breaks before you change it. Use when the user asks 'what uses this column/table/procedure', 'is it safe to change X', 'what depends on this', 'impact of renaming/dropping X', or before any schema/proc modification in an unfamiliar or legacy codebase. Not for privacy/PII exposure analysis (see data-breach-blast-radius) or query performance tuning (see sql-optimization).

## When your agent uses it

> Before modifying a table, column, stored procedure, view, or trigger in a legacy codebase, trace every place that references it — across other SQL objects (procs, views, triggers) AND application code (C#, Angular/TypeScript, JS, or any language in the repo) — and produce a structured blast-radius report so you know what breaks before you change it. Use when the user asks 'what uses this column/table/procedure', 'is it safe to change X', 'what depends on this', 'impact of renaming/dropping X', or before any schema/proc modification in an unfamiliar or legacy codebase. Not for privacy/PII exposure analysis (see data-breach-blast-radius) or query performance tuning (see sql-optimization).

## What it can access

From a static check of the files on GitHub; nothing was run.

- [Instructions only, no scripts](https://github.com/github/awesome-copilot/tree/HEAD/skills/sql-object-impact-analysis)
- [License: MIT](https://github.com/github/awesome-copilot/tree/HEAD/skills/sql-object-impact-analysis)

## Install

### Claude Code

Copy the skill folder to `~/.claude/skills/sql-object-impact-analysis` to use it in all your projects:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.claude/skills &&
rm -rf ~/.claude/skills/sql-object-impact-analysis &&
cp -R "$tmp/skills/sql-object-impact-analysis" ~/.claude/skills/sql-object-impact-analysis &&
rm -rf "$tmp"
```

For one project only, put the folder in `.claude/skills/sql-object-impact-analysis` inside it instead.

### Codex

Copy the skill folder to `~/.agents/skills/sql-object-impact-analysis` to use it in every repository:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.agents/skills &&
rm -rf ~/.agents/skills/sql-object-impact-analysis &&
cp -R "$tmp/skills/sql-object-impact-analysis" ~/.agents/skills/sql-object-impact-analysis &&
rm -rf "$tmp"
```

For one repository only, put the folder in `.agents/skills/sql-object-impact-analysis` inside it instead.

### Cursor

Copy the skill folder to `~/.cursor/skills/sql-object-impact-analysis` to use it in every project:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.cursor/skills &&
rm -rf ~/.cursor/skills/sql-object-impact-analysis &&
cp -R "$tmp/skills/sql-object-impact-analysis" ~/.cursor/skills/sql-object-impact-analysis &&
rm -rf "$tmp"
```

For one project only, put the folder in `.cursor/skills/sql-object-impact-analysis` inside it instead.

### Gemini CLI

Run in a terminal (add `--scope workspace` to install it for the current workspace only):

```sh
gemini skills install https://github.com/github/awesome-copilot.git --path skills/sql-object-impact-analysis
```

Or copy the folder to `~/.gemini/skills/sql-object-impact-analysis` yourself.

### VS Code

For GitHub Copilot in VS Code, copy the skill folder to `~/.copilot/skills/sql-object-impact-analysis`:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.copilot/skills &&
rm -rf ~/.copilot/skills/sql-object-impact-analysis &&
cp -R "$tmp/skills/sql-object-impact-analysis" ~/.copilot/skills/sql-object-impact-analysis &&
rm -rf "$tmp"
```

For one project only, put the folder in `.github/skills/sql-object-impact-analysis` inside it instead.

### Other agents

Get the folder:

```sh
git clone --depth 1 https://github.com/github/awesome-copilot.git
```

Then copy `awesome-copilot/skills/sql-object-impact-analysis` into your agent's skills folder as `sql-object-impact-analysis`. Agents that support SKILL.md read one folder per skill.

## FAQ

### How do I install SQL object impact analysis in Claude Code?

Copy the skill folder from GitHub to ~/.claude/skills/sql-object-impact-analysis to use it in all your projects, or to .claude/skills/sql-object-impact-analysis in one project.

### Does SQL object impact analysis run scripts?

No. It is instructions only, with no scripts. This comes from a static check of the files on GitHub; nothing was run. Read the files before you install it.

### Which AI agents can use SQL object impact analysis?

Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose. Each reads skills in the SKILL.md format from its own folder; the install steps on this page list them.

### What are the best alternatives to SQL object impact analysis?

The closest alternatives to SQL object impact analysis are Snowflake semanticview, Migrating oracle to postgres stored procedures, Postgresql optimization, Bigquery pipeline audit and Supabase rls policies.

## Alternatives

- [Snowflake semanticview](https://ai-powered.com/skills/snowflake-semanticview): Snowflake semanticview is an open-source agent skill for databases.
- [Migrating oracle to postgres stored procedures](https://ai-powered.com/skills/migrating-oracle-to-postgres-stored-procedures): Migrating oracle to postgres stored procedures is an open-source agent skill for databases.
- [Postgresql optimization](https://ai-powered.com/skills/postgresql-optimization): Postgresql optimization is an open-source agent skill for databases.
- [Bigquery pipeline audit](https://ai-powered.com/skills/bigquery-pipeline-audit): Bigquery pipeline audit is an open-source agent skill for databases.
- [Supabase rls policies](https://ai-powered.com/skills/supabase-rls-policies): Supabase rls policies is an open-source agent skill for databases.
- [SQL server table reconciliation](https://ai-powered.com/skills/sql-server-table-reconciliation): SQL server table reconciliation is an open-source agent skill for databases.
- [Creating oracle to postgres migration integration tests](https://ai-powered.com/skills/creating-oracle-to-postgres-migration-integration-tests): Creating oracle to postgres migration integration tests is an open-source agent skill for databases.
- [Migrating oracle to postgres data access code](https://ai-powered.com/skills/migrating-oracle-to-postgres-data-access-code): Migrating oracle to postgres data access code is an open-source agent skill for databases.

---
Source: https://ai-powered.com/skills/sql-object-impact-analysis
