CtrlK
BlogDocsLog inGet started
Tessl Logo

testland/multi-engine-row-level-security-reference

Pure-reference catalog of row/tenant isolation mechanisms across four database engines: MySQL and MariaDB (no native RLS - views with SQL SECURITY INVOKER plus app-layer enforcement), CockroachDB (native RLS via ALTER TABLE ENABLE ROW LEVEL SECURITY and CREATE POLICY, matching Postgres semantics), Vitess (keyspace sharding + vindexes route tenant writes to dedicated shards without a policy layer), and SQL Server (CREATE SECURITY POLICY with inline table-valued function filter/block predicates). Covers the isolation mechanism, tenant-context pattern, bypass risks, and test patterns for each engine. Use when designing or auditing tenant isolation on MySQL, MariaDB, CockroachDB, Vitess, or SQL Server.

79

Quality

99%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

Overview
Quality
Evals
Security
Files

Quality

Content

100%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A well-structured reference skill: concise, actionable per-engine SQL with inline test expectations, clear navigation to one-level-deep reference files that are verified present, and a useful anti-patterns table. Content respects token budget while remaining complete.

DimensionReasoningScore

Conciseness

Lean body that assumes competence: no explaining what RLS or a database is, each section opens with the isolation primitive and gives minimal executable SQL, and version numbers are confined to external reference links rather than inlined.

3 / 3

Actionability

Each engine section ships executable SQL annotated with expected outcomes (e.g. '-- must be denied', '-- violates WITH CHECK', '-- fails: key is read-only'), and the anti-patterns table pairs each failure mode with a concrete fix.

3 / 3

Workflow Clarity

This is a reference/catalog skill whose single action (look up an engine's isolation mechanism and tests) is unambiguous via the cheat sheet plus per-engine sections; per the simple-skills note workflow clarity can score 3, and no destructive batch operation is present to require validation checkpoints.

3 / 3

Progressive Disclosure

A concise overview and cheat sheet lead into four well-signaled one-level-deep references (e.g. '[references/mysql-mariadb.md](references/mysql-mariadb.md)'); the referenced files exist and link only to external docs, with no nested .md chaining.

3 / 3

Total

12

/

12

Passed

Description

100%

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong, specific description that states concrete per-engine actions, explicit use-when triggers, and a clearly bounded niche. Third person is maintained throughout and it is clearly distinguishable from sibling skills.

DimensionReasoningScore

Specificity

Names multiple concrete actions per engine, e.g. 'ALTER TABLE ENABLE ROW LEVEL SECURITY and CREATE POLICY', 'CREATE SECURITY POLICY with inline table-valued function filter/block predicates', and 'keyspace sharding + vindexes route tenant writes to dedicated shards'.

3 / 3

Completeness

Explicitly states what it covers ('Covers the isolation mechanism, tenant-context pattern, bypass risks, and test patterns for each engine') and when to use it ('Use when designing or auditing tenant isolation on ...'), satisfying both halves.

3 / 3

Trigger Term Quality

Includes the natural engine names users would say (MySQL, MariaDB, CockroachDB, Vitess, SQL Server) plus the trigger phrase 'Use when designing or auditing tenant isolation on ...'; coverage is broad and natural rather than jargon.

3 / 3

Distinctiveness Conflict Risk

The four-engine row/tenant-isolation niche is highly specific and explicitly scoped as the non-Postgres complement to a Postgres skill, making accidental triggering of the wrong skill unlikely.

3 / 3

Total

12

/

12

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

metadata_version

'metadata.version' is missing

Warning

Total

15

/

16

Passed

Reviewed

Table of Contents