mediar-ai/postgres
packages/skills/skills/postgres/SKILL.md
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
$ install --global
skillsauthnpx skillsauth add mediar-ai/skillhubz postgresInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 19, 2026, 4:21 AM4.0s1 file scanned
SKILL.md
- name:
- postgres
- description:
- PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
- license:
- MIT
- author:
- planetscale
- version:
- 1.0.0
PlanetScale Postgres
Generic Postgres
| Topic | Reference | Use for | | ---------------------- | ---------------------------------------------------------------- | --------------------------------------------------------- | | Schema Design | references/schema-design.md | Tables, primary keys, data types, foreign keys | | Indexing | references/indexing.md | Index types, composite indexes, performance | | Index Optimization | references/index-optimization.md | Unused/duplicate index queries, index audit | | Partitioning | references/partitioning.md | Large tables, time-series, data retention | | Query Patterns | references/query-patterns.md | SQL anti-patterns, JOINs, pagination, batch queries | | Optimization Checklist | references/optimization-checklist.md | Pre-optimization audit, cleanup, readiness checks | | MVCC and VACUUM | references/mvcc-vacuum.md | Dead tuples, long transactions, xid wraparound prevention |
Operations and Architecture
| Topic | Reference | Use for | | ---------------------- | ---------------------------------------------------------------------------- | --------------------------------------------------------------- | | Process Architecture | references/process-architecture.md | Multi-process model, connection pooling, auxiliary processes | | Memory Architecture | references/memory-management-ops.md | Shared/private memory layout, OS page cache, OOM prevention | | MVCC Transactions | references/mvcc-transactions.md | Isolation levels, XID wraparound, serialization errors | | WAL and Checkpoints | references/wal-operations.md | WAL internals, checkpoint tuning, durability, crash recovery | | Replication | references/replication.md | Streaming replication, slots, sync commit, failover | | Storage Layout | references/storage-layout.md | PGDATA structure, TOAST, fillfactor, tablespaces, disk mgmt | | Monitoring | references/monitoring.md | pg_stat views, logging, pg_stat_statements, host metrics | | Backup and Recovery | references/backup-recovery.md | pg_dump, pg_basebackup, PITR, WAL archiving, backup tools |
PlanetScale-Specific
| Topic | Reference | Use for |
| ------------------ | ---------------------------------------------------------------------------- | ----------------------------------------------------- |
| Connection Pooling | references/ps-connection-pooling.md | PgBouncer, pool sizing, pooled vs direct |
| Extensions | references/ps-extensions.md | Supported extensions, compatibility |
| Connections | references/ps-connections.md | Connection troubleshooting, drivers, SSL |
| Insights | references/ps-insights.md | Slow queries, MCP server, pscale CLI |
| CLI Commands | references/ps-cli-commands.md | pscale CLI reference, branches, deploy requests, auth |
| CLI API Insights | references/ps-cli-api-insights.md | Query insights via pscale api, schema analysis |
Related Skills
mediar-ai/tui-ui
tools
VerifiedTrustedCommunity
Design web-like user interfaces in the terminal and inside tmux with a cell-grid Canvas, CSS-like box model, flexbox/grid layout, and 15 reusable widgets such as Panel, Table, Card, ProgressBar, Meter, Tabs, Tree, Badge, Banner, and a braille line chart. Use when an agent needs a dashboard, panel, table, status page, TUI layout, tmux dashboard, screenshot-driven CLI/TUI replica, ANSI frame, truecolor render, pyte PNG screenshot smoke test, wide-character alignment, or a new terminal widget.
7SKILL.mdUpdated Jul 11, 2026
mediar-ai/drive-tui
tools
VerifiedTrustedCommunity
Drive interactive terminal (TUI) programs — CLIs, REPLs, installers, menu apps, agent CLIs, and editors like vim — through a PTY, reading semantic screen snapshots. A pattern library classifies a screen (REPL, menu, pager, fzf search, confirm dialog, form, spinner, wizard) and drives it with a ready recipe. Use when a program expects a live terminal (arrow-key menus, prompts, spinners, password fields, curses UIs), or when a piped command hangs or prints nothing.
7SKILL.mdUpdated Jul 11, 2026
mediar-ai/cmd-art
tools
VerifiedTrustedCommunity
Design and render terminal/CMD visual effects and ASCII art from a one-line request via the pluggable `fx` engine (18 hot-swappable, themeable effects plus scripted shows). Effects include donut, matrix rain, plasma, fire, a spinning 3D ball, Game of Life, wireframe cube, 3D text banners, rainbow/lolcat gradient text, starfield, tunnel, fireworks, image-to-ASCII, and more. Use when the request is for a terminal animation, ANSI/CLI art, or a new console effect. Pure Python stdlib; truecolor.
7SKILL.mdUpdated Jul 11, 2026
mediar-ai/packages/skills/skills/x-twitter-scraper
tools
VerifiedTrustedCommunity
# X Twitter Scraper Use Xquik for X/Twitter tweet search, user lookup, profile tweets, follower export, media download, monitors, webhooks, posting workflows, and MCP-backed API exploration. ## Prerequisites - A Xquik API key in `XQUIK_API_KEY`. - Internet access to `https://xquik.com/api/v1`, `https://xquik.com/mcp`, and `https://docs.xquik.com`. - A clear user request that identifies the target tweets, users, accounts, keywords, media, monitor, webhook, or write action. ## Source Truth -
6SKILL.mdUpdated May 31, 2026