Postgresql Patterns Library
Коллекция готовых SQL запросов для PostgreSQL по часто возникающим задачам (получение и модификация данных, ускорение запросов, обслуживание БД)
Supply asset profile
Data, BI, and analytics
CSV, SQL, notebooks, dashboards, data pipelines, BI, ETL, and spreadsheet analysis.
Scenario
Database and SQL
I need my agent to inspect database schemas, write SQL, and explain query results.
Agent fit
Claude Code + CLI + Codex
Codex, Claude Code, Cursor, CLI, or custom agents.
Install
Ready
npx skills add rin-nas/postgresql-patterns-library
Maintenance
fresh
5d since push
Risk
Safe to try
Quality score needs review
GitHub quality
777
86/100 quality · 88/100 trust
Coverage tags
Review notes
Quality score needs review
Agent adoption scorecard
Trust, audit, and install readiness at a glance
These scores combine public repository metadata, OpenAgentSkill review signals, maintenance freshness, and install readiness. They are a shortlist signal, not a replacement for human review.
Quality
ExcellentHigh-confidence pick with strong adoption and healthy maintenance signals.
Trust
Production candidateStrong OpenAgentSkill Trust Score across adoption, recent maintenance, license clarity, documentation, dependency risk, and install availability.
Audit
Safe to tryInstall readiness, security metadata, maintenance, and adoption risk.
Agent safety v2
71/100 · Review before install
Good audit and safety signals with no high-risk permission hints in public metadata.
Review the audit page, then allow agent install in a sandboxed workflow.
medium
Network access
Skill likely fetches remote pages, APIs, repositories, or external services.
medium
Filesystem access
Skill may read or write project files, documents, generated artifacts, or local workspace state.
medium
Database access
Skill may inspect schemas, query databases, or work with persistent stores.
- Quality score needs review
Install targets
Install this skill in your agent workflow
Copy the registry command or an agent-specific install prompt for Codex, Claude Code, and Cursor.
OpenAgentSkill CLI
Use the registry command when your workflow supports the OpenAgentSkill installer.
$ npx skills add rin-nas/postgresql-patterns-libraryAgent resolve plan
Let an agent verify fit before installing.
The Resolve API returns the selected skill, alternatives, safety policy, audit notes, install target, and copy-paste prompt an agent can follow without scraping this page.
Resolve JSON
/api/agent/resolve?task=Use%20Postgresql%20Patterns%20Library%20for%20an%20agent%20workflow&agent=codex&max_risk=medium
Resolve text
/api/agent/resolve?task=Use%20Postgresql%20Patterns%20Library%20for%20an%20agent%20workflow&agent=codex&max_risk=medium&format=text
Install handoff
/api/skills/rin-nas-postgresql-patterns-library/install
Agent should check
- Task fit and alternatives from Resolve API.
- Audit score, trust score, and safety policy warnings.
- Install target compatibility for Codex, Claude Code, Cursor, or CLI.
Copy prompt
Task: Use Postgresql Patterns Library in this workspace.
Resolve first: https://www.openagentskill.com/api/agent/resolve?task=Use%20Postgresql%20Patterns%20Library%20for%20an%20agent%20workflow&agent=codex&max_risk=medium
Review install handoff: https://www.openagentskill.com/api/skills/rin-nas-postgresql-patterns-library/install
Install command: npx skills add rin-nas/postgresql-patterns-library
Before running it, summarize audit warnings, required permissions, and the fallback skill if install is risky.Agent handoff
Give an agent the install path, not another directory page.
Use the public install endpoint to fetch the command, safety checklist, target prompts, and canonical links for this skill.
Install handoff
/api/skills/rin-nas-postgresql-patterns-library/install
LLM text format
/api/skills/rin-nas-postgresql-patterns-library/install?format=text
Find alternatives
/api/skills/search?q=Postgresql%20Patterns%20Library&limit=3
Agent prompt
Use Postgresql Patterns Library for this task. Review https://www.openagentskill.com/api/skills/rin-nas-postgresql-patterns-library/install, then install with: npx skills add rin-nas/postgresql-patterns-libraryRegistry metadata
Agent-readable profile for automatic skill selection.
This page exposes the same decision, trust, audit, use-case, and install signals through the Registry API, so agents can rank this skill without scraping the UI.
Manifest
/api/registry/manifest/rin-nas-postgresql-patterns-library
LLM text
/api/registry/manifest/rin-nas-postgresql-patterns-library?format=text
Install alias
/api/registry/install/rin-nas-postgresql-patterns-library
Recommend
/api/registry/recommend?task=Use%20Postgresql%20Patterns%20Library%20in%20an%20agent%20workflow&limit=3
Agent fit
Workflow automation
Use-case tags
Platforms
PLpgSQL, SQL, Claude Code
Audit report
Safe to try · 91/100
Review install readiness, maintenance, trust, quality, and metadata warnings before adding this skill to an agent workflow.
Agent decision cockpit
Primary pick for Workflow automation
Use this as a leading candidate, then validate the README and install path in your own agent stack.
Role in stack
Primary pick
Primary fit
Workflow automation
Trust label
Production-ready
Install path
Command ready
Use when
- Workflow automation workflows
- Claude Code teams
- teams that value GitHub adoption signals
Evidence
- 777 GitHub stars
- recent repository activity
- install command or GitHub repo available
- 86/100 quality profile
Review first
- No OpenAgentSkill engagement data yet
Implementation path
- 1Install it in a sandbox agent and run one Workflow automation task end to end.
- 2Compare output quality, latency, and failure behavior against at least one alternative.
- 3Promote it into production only after reviewing repository permissions, license, and maintenance signals.
Trust profile
Production candidate
Strong OpenAgentSkill Trust Score across adoption, recent maintenance, license clarity, documentation, dependency risk, and install availability.
GitHub adoption
INFO777 GitHub stars
Recent maintenance
PASS5d since push
License clarity
PASSMIT
README/SKILL.md completeness
PASSMetadata includes enough usage and workflow context
Good signals
- AI review approved
- Install path is available
- Repository evidence is available
- Recently maintained repository
- Meaningful GitHub adoption signal
Review before install
- Quality score needs review
Recommended action
Shortlist for production use, then run a normal repository and dependency review.
Quality profile
Excellent candidate for agent workflows
High-confidence pick with strong adoption and healthy maintenance signals.
Workflow fit
Use this skill in these scenarios
Automate repeated work
Workflow automation
I need my agent to automate a repeated workflow across tools and files.
Build and ship code
Coding agents
I need a coding agent that can understand a repository, edit code, and review pull requests.
Search private knowledge
RAG and knowledge
I need my agent to build a RAG workflow over documents and retrieve reliable context.
Stack fit
Add it to a complete workflow
Turn skills into distribution
Content growth agent
A stack for turning newly indexed skills into SEO briefs, social drafts, comparison pages, and reusable publishing workflows.
Inspect, patch, and verify code
Coding review agent
A stack for software agents that inspect repositories, review pull requests, generate tests, and turn findings into shippable patches.
Ingest, retrieve, and cite
RAG knowledge base
A stack for document-heavy agents that ingest files, create searchable knowledge, retrieve relevant context, and answer with grounded sources.
Alternative shortlist
Compare before you install
Similar skills in this category, ranked with the same readiness and quality signals.
D3
Bring data to life with SVG, Canvas and HTML. :bar_chart::chart_with_upwards_trend::tada:
Grafana
The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
Superset
Apache Superset is a Data Visualization and Data Exploration Platform
Echarts
Apache ECharts is a powerful, interactive charting and data visualization library for browser
Overview
Коллекция готовых SQL запросов для PostgreSQL по часто возникающим задачам (получение и модификация данных, ускорение запросов, обслуживание БД)
Imported by the skill-only GitHub discovery pipeline because it matches agent skill, automation, domain workflow, RAG, document-processing, data, finance, security, or developer-tool signals. Protocol-server projects are excluded from automated imports.
Platform Compatibility
Technical Details
- Version
- 1.0.0
- License
- MIT
- Last Updated
- 6/16/2026
- Published
- 6/13/2026
Frameworks & Tools
Decision snapshot
Primary pick
777 GitHub stars
Audit Snapshot
Install and adoption review
- Security
- 96/100
- Maintenance
- 100/100
- Install
- 92/100
Growth loop
Share this skill
Scenario-led draft for Postgresql Patterns Library, with the OpenAgentSkill Update theme and canonical URL.
OpenAgentSkill Update Today: Postgresql Patterns Library Use it when your agent needs to turn docs, data, or knowledge bases into answers... 777 stars - data-analysis Link: https://www.openagentskill.com/skills/rin-nas-postgresql-patterns-library?ref=x #AIAgents #OpenAgentSkill
Optional reply with install command
Link for Postgresql Patterns Library: https://www.openagentskill.com/skills/rin-nas-postgresql-patterns-library?ref=x Install: npx skills add rin-nas/postgresql-patterns-library
Listing source
Community indexed
This listing was indexed from public sources and is not marked official until a maintainer claim is approved.
- Creator
- rin-nas
- Indexed by
- OpenAgentSkill community index
Attribution links to the public repository or creator profile. Creators can claim the listing to update ownership signals.
Claim this skillOwner claim
Claim this skill listing
This community indexed listing is attributed to rin-nas but is not marked official yet. Claim it to add a verified owner signal and make future launch, install, and audit updates easier to trust.
README badge
Add this badge to your GitHub README to show the listing, trust score, and install handoff.
[](https://www.openagentskill.com/skills/rin-nas-postgresql-patterns-library)Author
rin-nas
@rin-nas
Platform Fit
Health Signals
- GitHub stars
- 777
- Quality score
- 54/100
- Last GitHub push
- Jun 11, 2026
- Framework hints
- 2
- OpenAgentSkill views
- 0
- Install copies
- 0
- Outbound clicks
- 0
Community Signal
Share whether this skill looks useful for your agent workflow. Aggregated feedback improves rankings over time.
Trust & Safety
Production candidate
- GitHub adoption777 GitHub starsINFO
- Recent maintenance5d since pushPASS
- License clarityMITPASS
- README/SKILL.md completenessMetadata includes enough usage and workflow contextPASS
- Dependency riskdatabase surfacePASS
- Install availabilitynpx skills add rin-nas/postgresql-patterns-libraryPASS
Related Skills
D3
Bring data to life with SVG, Canvas and HTML. :bar_chart::chart_with_upwards_trend::tada:
113.1K stars · 0 installsGrafana
The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
74.4K stars · 0 installsSuperset
Apache Superset is a Data Visualization and Data Exploration Platform
73.3K stars · 0 installsEcharts
Apache ECharts is a powerful, interactive charting and data visualization library for browser
66.6K stars · 0 installs