aiskillstore/marketplace / skills/2025emma/postgresql
postgresql
UnverifiedPostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with PostgreSQL databases, writing SQL, or managing database systems.
Security report
UnverifiedStatic analysis of one exact version. It reduces risk and shows evidence; it does not certify that a skill is safe.
- Commit
75bf5843922e35c0edcbd8bd5f85db16fb540c72- Content hash
58d14ee13444f56ee1beeca2f75d880a3b19f51706cb5ebf3de72d7c23e872e6- Scanned
- 2026-11-17
- Scanner version
- skillxone-scan-1.0.0
- Policy version
- 0.1-draft
- Decision
- 1 open medium finding to review.
- Verification expires
- Not applicable
Findings (1 medium, 6 low)
A text file was not stored in full (it is a symbolic link, exceeds the size limit or could not be fetched), so it was not fully scanned.
Suggested fix: Keep skill files below the size limit and avoid symbolic links.
- low
INT-MISSING-LICENSENeither the skill nor its repository states a license, so the terms of use are unclear.
Suggested fix: Add a LICENSE file to the repository or a `license` field to SKILL.md.
A link uses unencrypted http:// (www.sunfreeware.com.), so its content can be altered in transit.
You can download Sun Studio from https://www.oracle.com/technetwork/server-storage/solarisstudio/downloads/. Many GNU tools are integrated into Solaris 10, or they are present on the Solaris companion CD. If you need packages for older ver…Suggested fix: Use https://.
A link uses unencrypted http:// (gnuwin32.sourceforge.net.), so its content can be altered in transit.
Diff is required to run the regression tests, and can be downloaded from http://gnuwin32.sourceforge.net.Suggested fix: Use https://.
A link uses unencrypted http:// (xmlsoft.org.), so its content can be altered in transit.
Required for XML support. Binaries can be downloaded from https://zlatkovic.com/pub/libxml or source from http://xmlsoft.org. Note that libxml2 requires iconv, which is available from the same download location.Suggested fix: Use https://.
A link uses unencrypted http:// (www.ossp.org), so its content can be altered in transit.
Required for UUID-OSSP support (contrib only). Source can be downloaded from http://www.ossp.org/pkg/lib/uuid/.Suggested fix: Use https://.
A link uses unencrypted http:// (xahlee.info), so its content can be altered in transit.
Replace /usr/local/pgsql/lib with whatever you set --libdir to in Step 1. You should put these commands into a shell start-up file such as /etc/profile or ~/.bash_profile. Some good information about the caveats associated with this method…Suggested fix: Use https://.
Checks run
- prompt-injection
- dangerous-commands
- credentials
- network
- file-access
- integrity
Checks skipped
- dependencies: No dependency manifest in the skill directory.
- gitleaks: gitleaks is not installed on this host.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |