New: 97,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Rust Sqlx Postgres Service

by hashgraph-online in hashgraph-online/awesome-codex-plugins

A skill your agent uses when adding, changing, testing, or reviewing Postgres persistence in Rust services that use sqlx, especially when designing migrations, query!

MITAuto-check passedTesting & QA

Install Rust Sqlx Postgres Service

skills CLI
$ npx skills add hashgraph-online/awesome-codex-plugins --skill rust-sqlx-postgres-service -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install hashgraph-online/awesome-codex-plugins rust-sqlx-postgres-service --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/hashgraph-online/awesome-codex-plugins.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/LVTD-LLC/skills/skills/rust-sqlx-postgres-service .claude/skills/rust-sqlx-postgres-service && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
rust-sqlx-postgres-service
GitHub stars
1.2k
Token cost
~938 tokens
SKILL.md length
409 words
Files
5 (incl. scripts, references)
Skills in repo
736
Repo updated
First seen
Licence
MIT

At a glance

A skill your agent uses when adding, changing, testing, or reviewing Postgres persistence in Rust services that use sqlx, especially when designing migrations, query!

  • Works in 8 steps: Inspect Cargo.toml, migrations/, .sqlx/,… → Design the schema change first. Create… → Prefer sqlx::query! and query_as! for… → …
  • Reviewing Postgres persistence in Rust services that use sqlx
  • SKILL.md covers Core Workflow, Migration Rules, Query Rules and Verification, plus 1 more section
  • Runs Shell scripts from its folder; calls cargo

What it does

Rust Sqlx Postgres Service is an agent skill from hashgraph-online/awesome-codex-plugins. Use when adding, changing, testing, or reviewing Postgres persistence in Rust services that use sqlx, especially when designing migrations, query! or queryas! calls, PgPool injection, transactions, compile-time checked SQL, SQLx offline mode, repository boundaries, or database-backed integration tests.

Its SKILL.md is about 940 tokens, which your agent loads only when the skill is triggered. The skill folder holds 7 other files, including scripts and reference files (for example `agents/openai.yaml`, `references/migration-safety.md` and `references/sqlx-patterns.md`). Compatibility notes: Codex, Claude Code, and other Agent Skills-compatible clients.

It sits in Testing & QA, covering Integration testing and SQL. It works with Rust, PostgreSQL and SQL. The repository describes itself as: A curated list of awesome OpenAI Codex / ChatGPT plugins, skills, and resources. The 1 Codex Marketplace. See live plugins at: https://hol.org/plugins/best-codex-plugins. The licence is MIT.

When your agent uses it

  • Reviewing Postgres persistence in Rust services that use sqlx
  • Especially when designing migrations

Example prompts

  • “/rust-sqlx-postgres-service”

Requirements

  • A Bash shell
  • Docker
  • Compatibility (from SKILL.md): Codex, Claude Code, and other Agent Skills-compatible clients.

Workflow steps

8 steps, taken from the first numbered list in SKILL.md.

  1. Inspect Cargo.toml, migrations/, .sqlx/, docker-compose.yml, CI, and
  2. Design the schema change first. Create or update a migration before writing
  3. Prefer sqlx::query! and query_as! for compile-time checked SQL. Use
  4. Inject PgPool, PgConnection, or Transaction explicitly. Do not create a
  5. Keep repository functions small and named by behavior. Return domain types
  6. Use a transaction for multi-step operations that must commit or roll back
  7. Add or update integration tests that run migrations and exercise the public
  8. Run the bundled preflight script or the repository's equivalent SQLx/Cargo

What it can do on your machine

Read from SKILL.md and the folder at commit 16b4156. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships 1 file in scripts/ (Shell), which the agent can run.

    Shell commands in SKILL.md call:

    • cargo

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

  • Compatibility

    Codex, Claude Code, and other Agent Skills-compatible clients.

    From compatibility in the SKILL.md frontmatter.

Context cost

Rust Sqlx Postgres Service loads about 938 tokens when it runs, and up to ~1.8k if it reads all its reference files. Until then it costs about 83 tokens; SKILL.md has 409 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~83
When it runs · the whole SKILL.md, loaded when a task matches
~938
With references · SKILL.md plus every file in references/, read only if the agent opens them
~1.8k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from hashgraph-online/awesome-codex-plugins at commit 16b4156, republished under its MIT licence (© hashgraph-online). 409 words, ~938 tokens.

Download SKILL.mdSave it as .claude/skills/rust-sqlx-postgres-service/SKILL.md (or your agent's skills folder). This skill also uses 4 other files; get the full folder from GitHub.
name
rust-sqlx-postgres-service
description
Use when adding, changing, testing, or reviewing Postgres persistence in Rust services that use sqlx, especially when designing migrations, query! or query_as! calls, PgPool injection, transactions, compile-time checked SQL, SQLx offline mode, repository boundaries, or database-backed integration tests.
compatibility
Codex, Claude Code, and other Agent Skills-compatible clients.
license
MIT
metadata.version
0.1.0
metadata.displayName
Rust SQLx Postgres Service
metadata.category
Rust
metadata.tags
rust,sqlx,postgres,migrations,persistence

Rust SQLx Postgres Service

Use this skill to make Rust/Postgres changes schema-first, compile-checked, and testable. Prefer explicit migrations, injected pools, narrow repository functions, and transaction boundaries that match the business operation.

Core Workflow

  1. Inspect Cargo.toml, migrations/, .sqlx/, docker-compose.yml, CI, and existing database helper modules before changing code.
  2. Design the schema change first. Create or update a migration before writing repository code that depends on it.
  3. Prefer sqlx::query! and query_as! for compile-time checked SQL. Use dynamic SQL only when the query shape truly changes at runtime.
  4. Inject PgPool, PgConnection, or Transaction explicitly. Do not create a pool inside handlers or repository functions.
  5. Keep repository functions small and named by behavior. Return domain types or persistence DTOs instead of leaking raw rows through the app.
  6. Use a transaction for multi-step operations that must commit or roll back together.
  7. Add or update integration tests that run migrations and exercise the public behavior when the change affects API semantics.
  8. Run the bundled preflight script or the repository's equivalent SQLx/Cargo CI commands.

Migration Rules

Read references/migration-safety.md before changing existing tables or data.

Default migration preferences:

  • Use additive changes first: new nullable columns, new tables, new indexes.
  • Backfill separately from schema creation when a table may be large.
  • Add not null, uniqueness, and foreign-key constraints only after existing data satisfies them.
  • Name constraints and indexes deliberately when they will appear in errors or operations.
  • Keep down migrations if the project uses them; otherwise document rollback expectations in the migration review.
Show full SKILL.md (157 more words)Show less

Query Rules

Read references/sqlx-patterns.md for SQLx macro, transaction, and offline mode details.

  • Prefer bind parameters over string interpolation.
  • Use fetch_optional for lookup-by-key operations.
  • Use execute for inserts/updates where row data is not needed.
  • Use RETURNING when the caller needs generated IDs or timestamps.
  • Check affected row counts for updates and deletes that should target exactly one row.
  • Map database uniqueness conflicts to domain errors near the repository edge.

Verification

Run from the Rust project root when the standard SQLx workflow applies:

bash
path/to/rust-sqlx-postgres-service/scripts/sqlx-preflight.sh

The script is conservative: it checks formatting and tests, inspects SQLx migration state when the CLI and DATABASE_URL are available, verifies SQLx offline metadata with cargo sqlx prepare --check when .sqlx/ or DATABASE_URL is available, and only applies migrations when RUST_SQLX_PREFLIGHT_RUN_MIGRATIONS=1 is set.

If the repository has a different CI command, use that command and explain why.

Reference Files

  • references/sqlx-patterns.md: query!, query_as!, pools, transactions, feature flags, and offline mode.
  • references/migration-safety.md: safe migration sequencing and rollout checks.

© hashgraph-online, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 4 other files (scripts, references) in plugins/LVTD-LLC/skills/skills/rust-sqlx-postgres-service of hashgraph-online/awesome-codex-plugins.

  • SKILL.md
  • agents/openai.yaml
  • references/migration-safety.md
  • references/sqlx-patterns.md
  • scripts/sqlx-preflight.sh

Open the folder on GitHubat commit 16b4156

Compare with similar skills

Rust Sqlx Postgres Service next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Rust Sqlx Postgres Service compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Rust Sqlx Postgres Service this skillhashgraph-online/awesome-codex-plugins1.2k—~938Automated safety check: PassMIT
Diesel Guardayarotsky/diesel-guard121—~3.1kAutomated safety check: PassMIT
Querying Tempotempoxyz/tidx107—~3.1kAutomated safety check: PassMIT
Ron Databasebionic-gpt/bionic-gpt2.4k—~721Automated safety check: PassApache-2.0
Mz PR ReviewMaterializeInc/materialize6.4k—~1.6kAutomated safety check: NotesCustom licence
Rust On Nailsbionic-gpt/bionic-gpt2.4k—~706Automated safety check: PassApache-2.0

Similar skills

  • Diesel Guard

    ayarotsky/diesel-guard

    Lints Diesel and SQLx Postgres migrations for unsafe schema changes that lock tables or cause downtime, and authors custom Rhai checks.

    121 GitHub stars~3.1k tokensUpdated 9 days ago
    DatabasesAuto-check passed

  • Querying Tempo

    tempoxyz/tidx

    Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx.

    107 GitHub stars~3.1k tokensUpdated yesterday
    DatabasesAuto-check passed

  • Ron Database

    bionic-gpt/bionic-gpt

    Manage PostgreSQL migrations, typed SQL queries, generated Rust bindings, and database authorization in Rust on Nails applications.

    2.4k GitHub stars~721 tokensUpdated today
    DatabasesAuto-check passed

  • Mz PR Review

    MaterializeInc/materialize

    Local code review of current branch vs Materialize standards.

    6.4k GitHub stars~1.6k tokensUpdated today
    DevelopmentAuto-check: notes

  • Rust On Nails

    bionic-gpt/bionic-gpt

    Design Rust on Nails applications and cross-layer features using Axum, server-rendered Dioxus, PostgreSQL, and typed SQL.

    2.4k GitHub stars~706 tokensUpdated today
    DatabasesAuto-check passed

  • Golem Add Postgres Rust

    golemcloud/golem

    Using golem:rdbms/postgres from a Rust Golem agent. An agent skill from golemcloud/golem.

    1.5k GitHub stars~551 tokensUpdated today
    DatabasesAuto-check passed

More from hashgraph-online/awesome-codex-plugins

All 736 skills in this repo

  • Anime Reaction Gif

    hashgraph-online/awesome-codex-plugins

    Create original anime-style reaction stickers as looping GIFs and MP4 previews, using generated character pose sheets and timed key poses.

    1.2k GitHub stars~922 tokensUpdated yesterday
    Auto-check passed

  • Calibredb

    hashgraph-online/awesome-codex-plugins

    Manage and query Calibre libraries with the calibredb CLI (local paths or Calibre Content server URLs).

    1.2k GitHub stars~1k tokensUpdated yesterday
    Auto-check passed

  • Rust API Test Harness

    hashgraph-online/awesome-codex-plugins

    A skill your agent uses when adding, changing, testing, or debugging Rust HTTP APIs and services, especially when Codex needs black-box integration tests, random-port app startup, real database test…

    1.2k GitHub stars~1.7k tokensUpdated yesterday
    Auto-check passed

  • Art

    hashgraph-online/awesome-codex-plugins

    Make a studio's game look like something at build time — a cover from a real frame of the game (free), painted covers, backdrops, textures and character plates from image models through the…

    1.2k GitHub stars~2.4k tokensUpdated yesterday
    Auto-check passed

  • Calle

    hashgraph-online/awesome-codex-plugins

    Use CALL-E from Codex through the calle CLI. An agent skill from hashgraph-online/awesome-codex-plugins.

    1.2k GitHub stars~2.9k tokensUpdated yesterday
    Auto-check passed

  • Game Balance Economy

    hashgraph-online/awesome-codex-plugins

    Balance game difficulty, resources, rewards, probability, progression, economies, and dominant strategies.

    1.2k GitHub stars~618 tokensUpdated yesterday
    Auto-check passed

Works with

Categories

Questions about Rust Sqlx Postgres Service

What does Rust Sqlx Postgres Service do?

A skill your agent uses when adding, changing, testing, or reviewing Postgres persistence in Rust services that use sqlx, especially when designing migrations, query! Rust Sqlx Postgres Service is an agent skill from hashgraph-online/awesome-codex-plugins. Use when adding, changing, testing, or reviewing Postgres persistence in Rust services that use sqlx, especially when designing migrations, query!

When should I use Rust Sqlx Postgres Service?

Rust Sqlx Postgres Service fits situations like: reviewing Postgres persistence in Rust services that use sqlx; especially when designing migrations.

How do I install Rust Sqlx Postgres Service in Claude Code?

Run `npx skills add hashgraph-online/awesome-codex-plugins --skill rust-sqlx-postgres-service -a claude-code`. Or copy the skill folder (plugins/LVTD-LLC/skills/skills/rust-sqlx-postgres-service in hashgraph-online/awesome-codex-plugins) into .claude/skills/rust-sqlx-postgres-service in your project. Claude Code loads it when a task matches its description.

How do I install Rust Sqlx Postgres Service in Codex?

Run `npx skills add hashgraph-online/awesome-codex-plugins --skill rust-sqlx-postgres-service -a codex`. Or copy the skill folder (plugins/LVTD-LLC/skills/skills/rust-sqlx-postgres-service in hashgraph-online/awesome-codex-plugins) into .agents/skills/rust-sqlx-postgres-service in your project. Codex loads it when a task matches its description.

Can I use Rust Sqlx Postgres Service in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add hashgraph-online/awesome-codex-plugins --skill rust-sqlx-postgres-service -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/rust-sqlx-postgres-service, .gemini/skills/rust-sqlx-postgres-service, .github/skills/rust-sqlx-postgres-service and .opencode/skills/rust-sqlx-postgres-service in your project.

What does Rust Sqlx Postgres Service need to run?

Going by SKILL.md and its folder, Rust Sqlx Postgres Service needs a shell for the scripts in its folder and the command-line tools its instructions call (cargo). Our summary lists: A Bash shell; Docker. Compatibility (from SKILL.md): Codex, Claude Code, and other Agent Skills-compatible clients..

Does Rust Sqlx Postgres Service access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Rust Sqlx Postgres Service safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Rust Sqlx Postgres Service use?

Rust Sqlx Postgres Service is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Rust Sqlx Postgres Service use?

About 938 tokens (SKILL.md is roughly 3.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 833 tokens, read only when the agent opens those files.

What are the alternatives to Rust Sqlx Postgres Service?

Skills that share tags, products or a category with Rust Sqlx Postgres Service: Diesel Guard (ayarotsky/diesel-guard, 121 stars), Querying Tempo (tempoxyz/tidx, 107 stars), Ron Database (bionic-gpt/bionic-gpt, 2.4k stars) and Mz PR Review (MaterializeInc/materialize, 6.4k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Rust Sqlx Postgres Service?

hashgraph-online (a GitHub organization) maintains it in hashgraph-online/awesome-codex-plugins, which has 1,232 GitHub stars. The repository holds 736 skills in this directory. The repository was last updated on October 6, 2026.

Source: hashgraph-online/awesome-codex-plugins on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.