Skip to content
140.0k
Log inGet started

BlogGuides

Indexing SQL, PostgreSQL and Terraform in one code graph

· 3 minute read

A code graph with SQL and Terraform is a graph that stores tables, views and cloud resources as nodes beside your functions and classes. Edges record which table references which, and which resource depends on which. Graphify, an open-source CLI, indexes all three locally in Graphify 0.8.36.

Why put schemas and infrastructure in the code graph?Link to Why put schemas and infrastructure in the code graph?

Many bugs cross the line between code, database and infrastructure. A column rename breaks a view. A database change breaks the function that reads its address. When schema files and Terraform sit in the same graph as the app, one query shows those links. You no longer need three tools and a whiteboard to trace them.

How do you enable SQL and Terraform support?Link to How do you enable SQL and Terraform support?

Install the optional extras. SQL support needs the sql extra, and Terraform needs the terraform extra. Terraform support covers .tf, .tfvars and .hcl files. In our test, a .sql file was skipped when the sql extra was missing. So check the install line first if tables do not appear.

bash
uv tool install "graphifyy[sql,terraform]"
graphify update .

What does Graphify extract from SQL?Link to What does Graphify extract from SQL?

It records tables and views as nodes, and foreign keys and view sources as edges. We tested a schema with users, orders and a big_orders view. Graphify 0.8.36 produced orders references users and big_orders reads_from orders. Both edges were tagged EXTRACTED, meaning they were parsed directly from the file.

sql
CREATE TABLE users (id SERIAL PRIMARY KEY, email TEXT NOT NULL);
CREATE TABLE orders (id SERIAL PRIMARY KEY, user_id INT REFERENCES users(id), total NUMERIC);
CREATE VIEW big_orders AS SELECT * FROM orders WHERE total > 100;

graphify explain "orders" showed the table at schema.sql L2 with these links:

text
<-- schema.sql [contains], --> users [references], <-- big_orders [reads_from]

What does Graphify extract from Terraform?Link to What does Graphify extract from Terraform?

It records resources as nodes and attribute references as edges. In our test, a Lambda function read the address of an RDS instance. Graphify produced aws_lambda_function.api references aws_db_instance.main, tagged EXTRACTED. graphify affected "aws_db_instance.main" then listed the function and its file and line, main.tf:L5.

hcl
resource "aws_lambda_function" "api" {
  function_name = "api"
  environment {
    variables = { DB_HOST = aws_db_instance.main.address }
  }
}

How do you index a live PostgreSQL database?Link to How do you index a live PostgreSQL database?

Use the postgres extra and point graphify extract at a connection string. Graphify added this on 7 June 2026. It introspects the live schema rather than reading migration files. That helps when the files have drifted from what is actually deployed. Use a read-only database user for this.

bash
uv tool install "graphifyy[postgres]"
graphify extract --postgres "postgresql://user:pass@host/db"

What are the limits?Link to What are the limits?

SQL inside application strings is not linked to tables. In our test, "SELECT * FROM orders" in a Python file created no edge to orders. ORMs and query builders need the same caution. Treat the graph as a map of declared schema and infrastructure, and read the code for runtime queries.

| Source | Needs | Edges we saw | |---|---|---| | .sql files | sql extra | references, reads_from | | Terraform .tf, .tfvars, .hcl | terraform extra | references | | Live PostgreSQL | postgres extra | Schema introspection | | SQL in app strings | Not extracted | None |

FAQLink to FAQ

Do I need an API key to index SQL or Terraform?Link to Do I need an API key to index SQL or Terraform?

No. graphify update . parses these files locally with no model.

Why are my tables missing from the graph?Link to Why are my tables missing from the graph?

Check that you installed the sql extra, then run graphify update . again.

Does Graphify read Terraform modules and variables?Link to Does Graphify read Terraform modules and variables?

It parses .tf, .tfvars and .hcl files. Check the graph for the references you need.

Is the PostgreSQL password stored in the graph?Link to Is the PostgreSQL password stored in the graph?

Pass credentials through an environment variable where possible, and use a read-only user.

Can I see which code depends on a resource?Link to Can I see which code depends on a resource?

Yes. Run graphify affected on the resource name to list what references it.

Get startedLink to Get started

Graphify is open source on GitHub. Install it with uv: uv tool install "graphifyy[sql,terraform]". See the Terraform language page and the querying docs. Related: Graphify CLI commands explained. See also how Graphify tags what it knows.

Try Graphify now.

Try for free