AcademyRulesData and reporting

PostgreSQL rules for Cursor

Data and backend teams writing schemas, queries and migrations for PostgreSQL.

  • Recommendedour rating
  • 40,892repository stars
  • CC0-1.0licence
  • 4 months agolast update
mkdir -p .cursor/rules && curl -fsSL https://raw.githubusercontent.com/PatrickJS/awesome-cursorrules/main/rules/postgresql.mdc -o .cursor/rules/postgresql.mdc
postgresql.mdc

Loading the file...

What it does

A Cursor rules file for working with PostgreSQL. It sets conventions for schemas, parameterized queries, indexing, versioned migrations and explicit transactions, and lists things to avoid such as SELECT *, string-interpolated SQL and schema changes during peak traffic.

Use cases

  1. 01Design a table with timestamps and foreign keys
  2. 02Write parameterized queries with explicit columns
  3. 03Plan a safe migration with a backfill step

Questions about
PostgreSQL rules for Cursor.

What is PostgreSQL rules for Cursor used for?

Data and backend teams writing schemas, queries and migrations for PostgreSQL. A Cursor rules file for working with PostgreSQL. It sets conventions for schemas, parameterized queries, indexing, versioned migrations and explicit transactions, and lists things to avoid such as SELECT *, string-interpolated SQL and schema changes during peak traffic.

How do I install PostgreSQL rules for Cursor?

Run this in your terminal: mkdir -p .cursor/rules && curl -fsSL https://raw.githubusercontent.com/PatrickJS/awesome-cursorrules/main/rules/postgresql.mdc -o .cursor/rules/postgresql.mdc

Is PostgreSQL rules for Cursor open source?

Yes. The code is on GitHub (PatrickJS/awesome-cursorrules) under the CC0-1.0 licence.

Is PostgreSQL rules for Cursor safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.