Skip to main content
Back to registry

postgresql-table-design

wshobson/agents

Enable with ALTER TABLE tbl ENABLE ROW LEVEL SECURITY . Create policies: CREATE POLICY user_access ON orders FOR SELECT TO app_users USING (user_id = current_user_id()) . Built-in user-based access control at the row level.

Installs6
Install command
npx skills add https://github.com/wshobson/agents --skill postgresql-table-design
Security audits
Gen Agent Trust HubPASS
SocketPASS
SnykPASS
About this skill
Enable with ALTER TABLE tbl ENABLE ROW LEVEL SECURITY . Create policies: CREATE POLICY user_access ON orders FOR SELECT TO app_users USING (user_id = current_user_id()) . Built-in user-based access control at the row level. - Define a PRIMARY KEY for reference tables (users, orders, etc.). Not always needed for time-series/event/log data. When used, prefer BIGINT GENERATED ALWAYS AS IDENTITY ; use UUID only when global uniqueness/opacity is needed. - Normalize first (to 3NF) to eliminate data redundancy and update anomalies; denormalize only for measured, high-ROI reads where join performance is proven problematic. Premature denormalization creates maintenance burden.

Source description provided by the upstream skill listing. Community reviews and install context appear in the sections below.

Community Reviews

Latest reviews

Sign in to review

No community reviews yet. Be the first to review.

Browse this skill in context
FAQ
What does postgresql-table-design do?

Enable with ALTER TABLE tbl ENABLE ROW LEVEL SECURITY . Create policies: CREATE POLICY user_access ON orders FOR SELECT TO app_users USING (user_id = current_user_id()) . Built-in user-based access control at the row level.

Is postgresql-table-design good?

postgresql-table-design does not have approved reviews yet, so SkillJury cannot publish a community verdict.

What agent does postgresql-table-design work with?

postgresql-table-design currently lists compatibility with Agent compatibility has not been published yet..

What are alternatives to postgresql-table-design?

Skills in the same category include telegram-bot-builder, flutter-app-size, sharp-edges, iterative-retrieval.

How do I install postgresql-table-design?

npx skills add https://github.com/wshobson/agents --skill postgresql-table-design

Related skills

More from wshobson/agents

Related skills

Alternatives in Software Engineering