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

Frl Test Coding Standard

by FoundationDB in FoundationDB/fdb-record-layer

Standards for writing tests in fdb-record-layer. An agent skill from FoundationDB/fdb-record-layer.

Apache-2.0Auto-check passedDatabases

Install Frl Test Coding Standard

skills CLI
$ npx skills add FoundationDB/fdb-record-layer --skill frl-test-coding-standard -a claude-code

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

GitHub CLI
$ gh skill install FoundationDB/fdb-record-layer frl-test-coding-standard --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/FoundationDB/fdb-record-layer.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/frl-test-coding-standard .claude/skills/frl-test-coding-standard && 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
frl-test-coding-standard
GitHub stars
675
Token cost
~792 tokens
SKILL.md length
239 words
Files
1
Skills in repo
10
Repo updated
First seen
Licence
Apache-2.0

At a glance

Standards for writing tests in fdb-record-layer. An agent skill from FoundationDB/fdb-record-layer.

  • Works in 3 steps: Create… → Register it in… → Decorate with…
  • Tasks that involve Code quality
  • SKILL.md covers Choosing the right test type, yaml-tests, JUnit tests and What not to do
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Frl Test Coding Standard is an agent skill from FoundationDB/fdb-record-layer. Standards for writing tests in fdb-record-layer. Apply when writing or reviewing test code. Some example usages: "Write a test for the new index type" "Help me write a yaml test for this SQL query"

Its SKILL.md is about 790 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Code quality, SQL and Unit testing. It works with SQL and JUnit. The repository describes itself as: A relational database with SQL support built on FoundationDB. The licence is Apache-2.0.

When your agent uses it

  • Tasks that involve Code quality
  • Tasks that involve SQL
  • Tasks that involve Unit testing

Example prompts

  • “Write a test for the new index type”
  • “Help me write a yaml test for this SQL query”
  • “Use the frl-test-coding-standard skill to standard for writing tests in fdb-record-layer. An agent skill from FoundationDB/fdb-record-layer”
  • “/frl-test-coding-standard”

Workflow steps

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

  1. Create yaml-tests/src/test/resources/-tests.yamsql.
  2. Register it in yaml-tests/src/test/java/YamlIntegrationTests.java with a @YamlTest
  3. Decorate with @MaintainYamlTestConfig(YamlTestConfigFilters.CORRECT_EXPECTATIONS) to

What it can do on your machine

Read from SKILL.md and the folder at commit 20a2376. 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

    No scripts in the folder and no shell commands in SKILL.md (its code samples are java and yaml).

    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.

Context cost

Frl Test Coding Standard loads about 792 tokens when it runs. Until then it costs about 56 tokens; SKILL.md has 239 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~56
When it runs · the whole SKILL.md, loaded when a task matches
~792

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); files beside SKILL.md are not scanned.

SKILL.md

The full file from FoundationDB/fdb-record-layer at commit 20a2376, republished under its Apache-2.0 licence (© FoundationDB). 239 words, ~792 tokens.

Download SKILL.mdSave it as .claude/skills/frl-test-coding-standard/SKILL.md (or your agent's skills folder).
name
frl-test-coding-standard
description
Standards for writing tests in fdb-record-layer. Apply when writing or reviewing test code. Some example usages: "Write a test for the new index type" "Help me write a yaml test for this SQL query"

Always apply the frl-coding-standard skill in addition to the standards below.

Choosing the right test type

What you're testingPreferred approach
SQL query behavior, query plans, result setsyaml-tests (.yamsql file)
JDBC-level interactionsJUnit test in fdb-relational-jdbc or fdb-relational-core
Record layer API (below SQL)JUnit test
Async / CompletableFuture edge casesJUnit test
Index maintenance, key expression logicJUnit test

When in doubt, prefer yaml-tests for anything reachable through SQL.

yaml-tests

Creating a new yamsql test file
  1. Create yaml-tests/src/test/resources/<feature>-tests.yamsql.
  2. Register it in yaml-tests/src/test/java/YamlIntegrationTests.java with a @YamlTest annotated method:
    java
    @YamlTest(schemaTemplateFiles = {}, queryFiles = "my-feature-tests.yamsql")
void myFeatureTests(YamlTest.Runner runner) throws Exception {
    runner.runYamsql();
}
  3. Decorate with @MaintainYamlTestConfig(YamlTestConfigFilters.CORRECT_EXPECTATIONS) to have the framework auto-populate expected query plans, metrics, and metadata on first run. Remove the annotation once the expected values are stable and reviewed.
yamsql file structure

See yaml-tests/src/test/resources/showcasing-tests.yamsql for a full reference. Key building blocks:

yaml
options:
  supported_version: 1.0.0     # minimum FRL version required

schema_template:               # declarative schema — reused across test blocks
  create table t (id bigint, name string, primary key(id))

setup:                         # DML run once before the test block
  - query: insert into t values (1, 'Alice'), (2, 'Bob')

test_block:
  preset: single_repetition_ordered
  tests:
    - query: select * from t where id = 1
      result:
        - [1, Alice]
    - query: explain select * from t where id = 1
      explain: "COVERING(...)"   # auto-filled by CORRECT_EXPECTATIONS on first run

Common result matchers: !ignore, !l (Long literal), !null, !not_null, !sc <substring> (string contains), !pos <value> (positional).

Debugging a yaml test

Add @DebugPlanner to the test method to launch PlannerRepl and inspect the plan interactively.

JUnit tests

  • Use JUnit 6 exclusively. No junit.framework or org.junit.Assert (checkstyle-banned).
  • Use AssertJ for assertions (org.assertj.core.api.Assertions).
  • Test method naming: <methodUnderTest><Condition><ExpectedResult>.
  • Extract shared setup into @BeforeEach or helper methods; DRY up after writing.

What not to do

  • Do not use Thread.sleep() to wait for async operations — use asyncToSync() or CompletableFuture composition.
  • Do not call join() or get() directly in test code if asyncToSync() is available on the context — it gives better error messages and timeout behavior.

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

Files

Just SKILL.md in .claude/skills/frl-test-coding-standard of FoundationDB/fdb-record-layer.

Open the folder on GitHubat commit 20a2376

Compare with similar skills

Frl Test Coding Standard 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.

Frl Test Coding Standard compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Frl Test Coding Standard this skillFoundationDB/fdb-record-layer675—~792Automated safety check: PassApache-2.0
Sap Abapsecondsky/sap-skills460—~3.9kAutomated safety check: PassGPL-3.0
SQL Code Reviewtotvs/engpro-advpl-tlpp-skills141—~3.5kAutomated safety check: PassMIT
SQL Code Reviewgithub/awesome-copilot40k1 repos~2.2kAutomated safety check: PassMIT
SQL Idiomsirahardianto/awesome-agv157—~1.5kAutomated safety check: PassMIT
Rust SQL Testshencangsheng/easydb_app590—~1.2kAutomated safety check: PassMIT

Similar skills

  • Sap Abap

    secondsky/sap-skills

    Comprehensive ABAP development skill for SAP systems. An agent skill from secondsky/sap-skills.

    460 GitHub stars~3.9k tokensUpdated 2 days ago
    DatabasesAuto-check passed

  • SQL Code Review

    totvs/engpro-advpl-tlpp-skills

    Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across SQL databases (PostgreSQL, SQL Server, Oracle).

    141 GitHub stars~3.5k tokensUpdated 2 days ago
    DatabasesAuto-check passed

  • SQL Code Review

    github/awesome-copilot

    Official

    Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle).

    40k GitHub starsUsed in 1 repo~2.2k tokens
    DatabasesAuto-check passed

  • SQL Idioms

    irahardianto/awesome-agv

    SQL coding standards: CTEs, explicit JOINs, index optimization, query execution plan analysis, transaction locking, and zero-downtime migration patterns.

    157 GitHub stars~1.5k tokensUpdated 2 days ago
    DatabasesAuto-check passed

  • Rust SQL Test

    shencangsheng/easydb_app

    Enforces unit test requirements for the Rust data-processing modules in src-tauri/src/sql/ (generator.rs, parse.rs) and src-tauri/src/reader/ (excel.rs and other readers).

    590 GitHub stars~1.2k tokensUpdated 1 mo ago
    Documents & OfficeAuto-check passed

  • Effect TS

    pproenca/dot-skills

    Effect-TS library usage in TypeScript — Effect.gen generators, Schema.Struct/Schema.Class definitions, Layer/Context.Tag/Service patterns, Effect.pipe pipelines, Data.TaggedError/Data.Class error…

    214 GitHub stars~2k tokensUpdated 1 mo ago
    DevelopmentAuto-check passed

More from FoundationDB/fdb-record-layer

All 10 skills in this repo

  • Relational Query Processor

    FoundationDB/fdb-record-layer

    Specialized skill for working in the fdb-relational-core SQL processing layer — parser, plan generator, and Cascades planner.

    675 GitHub stars~1k tokensUpdated today
    Auto-check passed

  • Using Gradle

    FoundationDB/fdb-record-layer

    A skill your agent uses when you need to build the project, compile code, or run tests.

    675 GitHub stars~705 tokensUpdated today
    Auto-check passed

  • Context Resumption

    FoundationDB/fdb-record-layer

    Rebuild working context after a session restart. An agent skill from FoundationDB/fdb-record-layer.

    675 GitHub stars~467 tokensUpdated today
    Auto-check passed

  • Docs Writer

    FoundationDB/fdb-record-layer

    Write or update documentation in docs/sphinx/source/. An agent skill from FoundationDB/fdb-record-layer.

    675 GitHub stars~925 tokensUpdated today
    Auto-check passed

  • Frl Coding Standard

    FoundationDB/fdb-record-layer

    Coding standards for all Java code in fdb-record-layer. An agent skill from FoundationDB/fdb-record-layer.

    675 GitHub stars~1.2k tokensUpdated today
    Auto-check passed

  • Stacked PRs

    FoundationDB/fdb-record-layer

    Create and manage stacked pull requests on FoundationDB/fdb-record-layer using the gh stack CLI extension.

    675 GitHub stars~1.9k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Frl Test Coding Standard

What does Frl Test Coding Standard do?

Standards for writing tests in fdb-record-layer. An agent skill from FoundationDB/fdb-record-layer. Frl Test Coding Standard is an agent skill from FoundationDB/fdb-record-layer. Standards for writing tests in fdb-record-layer.

When should I use Frl Test Coding Standard?

Frl Test Coding Standard fits situations like: tasks that involve Code quality; tasks that involve SQL; tasks that involve Unit testing.

How do I install Frl Test Coding Standard in Claude Code?

Run `npx skills add FoundationDB/fdb-record-layer --skill frl-test-coding-standard -a claude-code`. Or copy the skill folder (.claude/skills/frl-test-coding-standard in FoundationDB/fdb-record-layer) into .claude/skills/frl-test-coding-standard in your project. Claude Code loads it when a task matches its description.

How do I install Frl Test Coding Standard in Codex?

Run `npx skills add FoundationDB/fdb-record-layer --skill frl-test-coding-standard -a codex`. Or copy the skill folder (.claude/skills/frl-test-coding-standard in FoundationDB/fdb-record-layer) into .agents/skills/frl-test-coding-standard in your project. Codex loads it when a task matches its description.

Can I use Frl Test Coding Standard 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 FoundationDB/fdb-record-layer --skill frl-test-coding-standard -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/frl-test-coding-standard, .gemini/skills/frl-test-coding-standard, .github/skills/frl-test-coding-standard and .opencode/skills/frl-test-coding-standard in your project.

What does Frl Test Coding Standard need to run?

SKILL.md names no scripts, command-line tools or credentials: Frl Test Coding Standard is instructions for the agent only.

Does Frl Test Coding Standard 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 Frl Test Coding Standard 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. Review the folder before installing.

What licence does Frl Test Coding Standard use?

Frl Test Coding Standard is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Frl Test Coding Standard use?

About 792 tokens (SKILL.md is roughly 3.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Frl Test Coding Standard?

Skills that share tags, products or a category with Frl Test Coding Standard: Sap Abap (secondsky/sap-skills, 460 stars), SQL Code Review (totvs/engpro-advpl-tlpp-skills, 141 stars), SQL Code Review (github/awesome-copilot, 40k stars) and SQL Idioms (irahardianto/awesome-agv, 157 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Frl Test Coding Standard?

FoundationDB (a GitHub organization) maintains it in FoundationDB/fdb-record-layer, which has 675 GitHub stars. The repository holds 10 skills in this directory. The repository was last updated on October 6, 2026.

Source: FoundationDB/fdb-record-layer on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.