dbmask

Projects that follow the best practices below can voluntarily self-certify and show that they've achieved an Open Source Security Foundation (OpenSSF) best practices badge.

There is no set of practices that can guarantee that software will never have defects or vulnerabilities; even formal methods can fail if the specifications or assumptions are wrong. Nor is there any set of practices that can guarantee that a project will sustain a healthy and well-functioning development community. However, following best practices can help improve the results of projects. For example, some practices enable multi-person review before release, which can both help find otherwise hard-to-find technical vulnerabilities and help build trust and a desire for repeated interaction among developers from different companies. To earn a badge, all MUST and MUST NOT criteria must be met, all SHOULD criteria must be met OR be unmet with justification, and all SUGGESTED criteria must be met OR unmet (we want them considered at least). If you want to enter justification text as a generic comment, instead of being a rationale that the situation is acceptable, start the text block with '//' followed by a space. Feedback is welcome via the GitHub site as issues or pull requests There is also a mailing list for general discussion.

We gladly provide the information in several locales, however, if there is any conflict or inconsistency between the translations, the English version is the authoritative version.
If this is your project, please show your badge status on your project page! The badge status looks like this: Badge level for project 14225 is passing Here is how to embed it:
You can show your badge status by embedding this in your markdown file:
[![OpenSSF Best Practices](https://www.bestpractices.dev/projects/14225/badge)](https://www.bestpractices.dev/projects/14225)
or by embedding this in your HTML:
<a href="https://www.bestpractices.dev/projects/14225"><img src="https://www.bestpractices.dev/projects/14225/badge"></a>


These are the Passing level criteria. You can also view the Silver or Gold level criteria.

Baseline Series: Baseline Level 1 Baseline Level 2 Baseline Level 3

        

 Basics 13/13

  • General

    Note that other projects may use the same name.

    Discover, mask, and validate sensitive data in SQL databases — deterministic masking with built-in per-row verification. Works across PostgreSQL, MySQL, SQL Server, Oracle, and SQLite via SQLAlchemy.

    Please use SPDX license expression format; examples include "Apache-2.0", "BSD-2-Clause", "BSD-3-Clause", "GPL-2.0+", "LGPL-3.0+", "MIT", and "(BSD-2-Clause OR Ruby)". Do not include single quotes or double quotes.
    If there is more than one language, list them as comma-separated values (spaces optional) and sort them from most to least used. If there is a long list, please list at least the first three most common ones. If there is no language (e.g., this is a documentation-only or test-only project), use the single character "-". Please use a conventional capitalization for each language, e.g., "JavaScript".
    The Common Platform Enumeration (CPE) is a structured naming scheme for information technology systems, software, and packages. It is used in a number of systems and databases when reporting vulnerabilities.
  • Basic project website content


    The project website MUST succinctly describe what the software does (what problem does it solve?). [description_good]
    This MUST be in language that potential users can understand (e.g., it uses minimal jargon).

    The README and the documentation home page both open with a one-sentence description: dbmask discovers which columns of a SQL database hold sensitive data, masks them with deterministic realistic fakes, and then verifies row by row that the masking actually happened. https://sealandseacat.github.io/dbmask/



    The project website MUST provide information on how to: obtain, provide feedback (as bug reports or enhancements), and contribute to the software. [interact]

    The README covers all three. Obtain: pip install dbmask (https://pypi.org/project/dbmask/). Feedback: the GitHub issue tracker with bug-report, feature-request and adopter-feedback forms (https://github.com/sealandseacat/dbmask/issues/new/choose). Contribute: CONTRIBUTING.md (https://github.com/sealandseacat/dbmask/blob/main/CONTRIBUTING.md).



    The information on how to contribute MUST explain the contribution process (e.g., are pull requests used?) (URL required) [contribution]
    We presume that projects on GitHub use issues and pull requests unless otherwise noted. This information can be short, e.g., stating that the project uses pull requests, an issue tracker, or posts to a mailing list (which one?)

    CONTRIBUTING.md describes the process: fork, branch, open a pull request against main. CI must be green before merge (pytest on Python 3.9-3.14 plus Windows, ruff, mypy, an 80% coverage gate, and packaging checks). https://github.com/sealandseacat/dbmask/blob/main/CONTRIBUTING.md



    The information on how to contribute SHOULD include the requirements for acceptable contributions (e.g., a reference to any required coding standard). (URL required) [contribution_requirements]

    CONTRIBUTING.md states the requirements: every bug fix ships with a regression test that fails on the old code, ruff and mypy must be clean, the 80% coverage gate must hold, code must stay Python 3.9-compatible, and user-facing changes get a CHANGELOG entry. The pull request template repeats the test, sensitive-data, changelog and 3.9-compatibility requirements as a checklist. https://github.com/sealandseacat/dbmask/blob/main/CONTRIBUTING.md#pull-requests


  • FLOSS license


    The software produced by the project MUST be released as FLOSS. [floss_license]
    FLOSS is software released in a way that meets the Open Source Definition or Free Software Definition. Examples of such licenses include the CC0, MIT, BSD 2-clause, BSD 3-clause revised, Apache 2.0, Lesser GNU General Public License (LGPL), and the GNU General Public License (GPL). For our purposes, this means that the license MUST be: The software MAY also be licensed other ways (e.g., "GPLv2 or proprietary" is acceptable).

    The MIT license is approved by the Open Source Initiative (OSI).



    It is SUGGESTED that any required license(s) for the software produced by the project be approved by the Open Source Initiative (OSI). [floss_license_osi]
    The OSI uses a rigorous approval process to determine which licenses are OSS.

    The MIT license is approved by the Open Source Initiative (OSI).



    The project MUST post the license(s) of its results in a standard location in their source repository. (URL required) [license_location]
    One convention is posting the license as a top-level file named LICENSE or COPYING, which MAY be followed by an extension such as ".txt" or ".md". An alternative convention is to have a directory named LICENSES containing license file(s); these files are typically named as their SPDX license identifier followed by an appropriate file extension, as described in the REUSE Specification. Note that this criterion is only a requirement on the source repository. You do NOT need to include the license file when generating something from the source code (such as an executable, package, or container). For example, when generating an R package for the Comprehensive R Archive Network (CRAN), follow standard CRAN practice: if the license is a standard license, use the standard short license specification (to avoid installing yet another copy of the text) and list the LICENSE file in an exclusion file such as .Rbuildignore. Similarly, when creating a Debian package, you may put a link in the copyright file to the license text in /usr/share/common-licenses, and exclude the license file from the created package (e.g., by deleting the file after calling dh_auto_install). We encourage including machine-readable license information in generated formats where practical.

    Non-trivial license location file in repository: https://github.com/sealandseacat/dbmask/blob/main/LICENSE.


  • Documentation


    The project MUST provide basic documentation for the software produced by the project. [documentation_basics]
    This documentation must be in some media (such as text or video) that includes: how to install it, how to start it, how to use it (possibly with a tutorial using examples), and how to use it securely (e.g., what to do and what not to do) if that is an appropriate topic for the software. The security documentation need not be long. The project MAY use hypertext links to non-project material as documentation. If the project does not produce software, choose "not applicable" (N/A).

    A full MkDocs Material documentation site: https://sealandseacat.github.io/dbmask/ — getting started, configuration, masking strategies, the seed map, validation, LLM detection, architecture and the security model. The README also carries a verified 60-second quickstart.



    The project MUST provide reference documentation that describes the external interface (both input and output) of the software produced by the project. [documentation_interface]
    The documentation of an external interface explains to an end-user or developer how to use it. This would include its application program interface (API) if the software has one. If it is a library, document the major classes/types and methods/functions that can be called. If it is a web application, define its URL interface (often its REST interface). If it is a command-line interface, document the parameters and options it supports. In many cases it's best if most of this documentation is automatically generated, so that this documentation stays synchronized with the software as it changes, but this isn't required. The project MAY use hypertext links to non-project material as documentation. Documentation MAY be automatically generated (where practical this is often the best way to do so). Documentation of a REST interface may be generated using Swagger/OpenAPI. Code interface documentation MAY be generated using tools such as JSDoc (JavaScript), ESDoc (JavaScript), pydoc (Python), devtools (R), pkgdown (R), and Doxygen (many). Merely having comments in implementation code is not sufficient to satisfy this criterion; there needs to be an easy way to see the information without reading through all the source code. If the project does not produce software, choose "not applicable" (N/A).

    The command-line interface — scan, mask, validate, history, seeds, strategies — and its flags are documented across Getting started (https://sealandseacat.github.io/dbmask/getting-started/), the configuration reference (https://sealandseacat.github.io/dbmask/configuration/) and the guide pages for strategies, the seed map and validation. The library API is documented under "Using it as a library" on the Getting started page.


  • Other


    The project sites (website, repository, and download URLs) MUST support HTTPS using TLS. [sites_https]
    This requires that the project home page URL and the version control repository URL begin with "https:", not "http:". You can get free certificates from Let's Encrypt. Projects MAY implement this criterion using (for example) GitHub pages, GitLab pages, or SourceForge project pages. If you support HTTP, we urge you to redirect the HTTP traffic to HTTPS.

    Every project URL is HTTPS: the repository (https://github.com/sealandseacat/dbmask), the documentation site (https://sealandseacat.github.io/dbmask/, served by GitHub Pages), and the download URL (https://pypi.org/project/dbmask/).



    The project MUST have one or more mechanisms for discussion (including proposed changes and issues) that are searchable, allow messages and topics to be addressed by URL, enable new people to participate in some of the discussions, and do not require client-side installation of proprietary software. [discussion]
    Examples of acceptable mechanisms include archived mailing list(s), GitHub issue and pull request discussions, Bugzilla, Mantis, and Trac. Asynchronous discussion mechanisms (like IRC) are acceptable if they meet these criteria; make sure there is a URL-addressable archiving mechanism. Proprietary JavaScript, while discouraged, is permitted.

    GitHub issues and pull requests. Every issue and comment is searchable, addressable by its own URL, open to anyone with a GitHub account, and needs no proprietary client. https://github.com/sealandseacat/dbmask/issues



    The project SHOULD provide documentation in English and be able to accept bug reports and comments about code in English. [english]
    English is currently the lingua franca of computer technology; supporting English increases the number of different potential developers and reviewers worldwide. A project can meet this criterion even if its core developers' primary language is not English.

    All documentation, code, commit messages, issues and release notes are written in English.



    The project MUST be maintained. [maintained]
    As a minimum, the project should attempt to respond to significant problem and vulnerability reports. A project that is actively pursuing a badge is probably maintained. All projects and people have limited resources, and typical projects must reject some proposed changes, so limited resources and proposal rejections do not by themselves indicate an unmaintained project.

    When a project knows that it will no longer be maintained, it should set this criterion to "Unmet" and use the appropriate mechanism(s) to indicate to others that it is not being maintained. For example, use “DEPRECATED” as the first heading of its README, add “DEPRECATED” near the beginning of its home page, add “DEPRECATED” to the beginning of its code repository project description, add a no-maintenance-intended badge in its README and/or home page, mark it as deprecated in any package repositories (e.g., npm deprecate), and/or use the code repository's marking system to archive it (e.g., GitHub's "archive" setting, GitLab’s "archived" marking, Gerrit's "readonly" status, or SourceForge’s "abandoned" project status). Additional discussion can be found here.

    Actively maintained. v0.1.1 (2026-08-24) shipped fixes for seven tracked issues and one security advisory raised by a safety review of the released 0.1.0, three days after that first release, together with a documentation site, a hardened CI pipeline and a published threat model.


 Change Control 9/9

  • Public version-controlled source repository


    The project MUST have a version-controlled source repository that is publicly readable and has a URL. [repo_public]
    The URL MAY be the same as the project URL. The project MAY use private (non-public) branches in specific cases while the change is not publicly released (e.g., for fixing a vulnerability before it is revealed to the public).

    The project's source repository MUST track what changes were made, who made the changes, and when the changes were made. [repo_track]

    The repository is git, so every change records its author, timestamp and diff. https://github.com/sealandseacat/dbmask/commits/main



    To enable collaborative review, the project's source repository MUST include interim versions for review between releases; it MUST NOT include only final releases. [repo_interim]
    Projects MAY choose to omit specific interim versions from their public source repositories (e.g., ones that fix specific non-public security vulnerabilities, may never be publicly released, or include material that cannot be legally posted and are not in the final release).

    Work lands on main continuously through pull requests between releases; main is not a release-only branch. The v0.1.1 work was developed as a series of individually reviewable commits on the v0.1.1-hardening branch and merged as pull request #13.



    It is SUGGESTED that common distributed version control software be used (e.g., git) for the project's source repository. [repo_distributed]
    Git is not specifically required and projects can use centralized version control software (such as subversion) with justification.

    git.


  • Unique version numbering


    The project results MUST have a unique version identifier for each release intended to be used by users. [version_unique]
    This MAY be met in a variety of ways including a commit IDs (such as git commit id or mercurial changeset id) or a version number (including version numbers that use semantic versioning or date-based schemes like YYYYMMDD).

    Each release carries a unique version identifier declared in pyproject.toml and published under that version on PyPI and as a git tag: 0.1.0 and 0.1.1.



    It is SUGGESTED that the Semantic Versioning (SemVer) or Calendar Versioning (CalVer) version numbering format be used for releases. It is SUGGESTED that those who use CalVer include a micro level value. [version_semver]
    Projects should generally prefer whatever format is expected by their users, e.g., because it is the normal format used by their ecosystem. Many ecosystems prefer SemVer, and SemVer is generally preferred for application programmer interfaces (APIs) and software development kits (SDKs). CalVer tends to be used by projects that are large, have an unusually large number of independently-developed dependencies, have a constantly-changing scope, or are time-sensitive. It is SUGGESTED that those who use CalVer include a micro level value, because including a micro level supports simultaneously-maintained branches whenever that becomes necessary. Other version numbering formats may be used as version numbers, including git commit IDs or mercurial changeset IDs, as long as they uniquely identify versions. However, some alternatives (such as git commit IDs) can cause problems as release identifiers, because users may not be able to easily determine if they are up-to-date. The version ID format may be unimportant for identifying software releases if all recipients only run the latest version (e.g., it is the code for a single website or internet service that is constantly updated via continuous delivery).


    It is SUGGESTED that projects identify each release within their version control system. For example, it is SUGGESTED that those using git identify each release using git tags. [version_tags]

    Every release is tagged in git: v0.1.0, v0.1.1. https://github.com/sealandseacat/dbmask/tags


  • Release notes


    The project MUST provide, in each release, release notes that are a human-readable summary of major changes in that release to help users determine if they should upgrade and what the upgrade impact will be. The release notes MUST NOT be the raw output of a version control log (e.g., the "git log" command results are not release notes). Projects whose results are not intended for reuse in multiple locations (such as the software for a single website or service) AND employ continuous delivery MAY select "N/A". (URL required) [release_notes]
    The release notes MAY be implemented in a variety of ways. Many projects provide them in a file named "NEWS", "CHANGELOG", or "ChangeLog", optionally with extensions such as ".txt", ".md", or ".html". Historically the term "change log" meant a log of every change, but to meet these criteria what is needed is a human-readable summary. The release notes MAY instead be provided by version control system mechanisms such as the GitHub Releases workflow.

    https://github.com/sealandseacat/dbmask/blob/main/CHANGELOG.md — hand-written release notes in Keep a Changelog format, grouped into Security / Fixed / Added / Changed, with links to the individual issues and to the security advisory. The same notes form the body of each GitHub release.



    The release notes MUST identify every publicly known run-time vulnerability fixed in this release that already had a CVE assignment or similar when the release was created. This criterion may be marked as not applicable (N/A) if users typically cannot practically update the software themselves (e.g., as is often true for kernel updates). This criterion applies only to the project results, not to its dependencies. If there are no release notes or there have been no publicly known vulnerabilities, choose N/A. [release_notes_vulns]
    This criterion helps users determine if a given update will fix a vulnerability that is publicly known, to help users make an informed decision about updating. If users typically cannot practically update the software themselves on their computers, but must instead depend on one or more intermediaries to perform the update (as is often the case for a kernel and low-level software that is intertwined with a kernel), the project may choose "not applicable" (N/A) instead, since this additional information will not be helpful to those users. Similarly, a project may choose N/A if all recipients only run the latest version (e.g., it is the code for a single website or internet service that is constantly updated via continuous delivery). This criterion only applies to the project results, not its dependencies. Listing the vulnerabilities of all transitive dependencies of a project becomes unwieldy as dependencies increase and vary, and is unnecessary since tools that examine and track dependencies can do this in a more scalable way.

    The v0.1.1 release notes open with a Security section that names the one vulnerability fixed in that release and links its advisory, GHSA-2jwm-hcfc-72xm (https://github.com/sealandseacat/dbmask/security/advisories/GHSA-2jwm-hcfc-72xm). No other publicly known vulnerability has affected this project.


 Reporting 8/8

  • Bug-reporting process


    The project MUST provide a process for users to submit bug reports (e.g., using an issue tracker or a mailing list). (URL required) [report_process]

    https://github.com/sealandseacat/dbmask/issues/new/choose — the project uses GitHub issues, with structured forms for bug reports, feature requests and adopter feedback.



    The project SHOULD use an issue tracker for tracking individual issues. [report_tracker]

    The project MUST acknowledge a majority of bug reports submitted in the last 2-12 months (inclusive); the response need not include a fix. [report_responses]

    Every issue filed on this project so far has been answered and closed. Issues #6 to #12, raised by a safety review of the released 0.1.0, were fixed and closed by pull request #13 in v0.1.1; the earlier reports #1, #2 and #3 were addressed in v0.1.0. Nothing is outstanding. https://github.com/sealandseacat/dbmask/issues?q=is%3Aissue+is%3Aclosed



    The project SHOULD respond to a majority (>50%) of enhancement requests in the last 2-12 months (inclusive). [enhancement_responses]
    The response MAY be 'no' or a discussion about its merits. The goal is simply that there be some response to some requests, which indicates that the project is still alive. For purposes of this criterion, projects need not count fake requests (e.g., from spammers or automated systems). If a project is no longer making enhancements, please select "unmet" and include the URL that makes this situation clear to users. If a project tends to be overwhelmed by the number of enhancement requests, please select "unmet" and explain.

    The one enhancement suggestion received from outside the project so far, issue #1, was accepted and shipped in v0.1.0 — it prompted the README repositioning and the use-cases and roadmap sections, with credit in the changelog. No enhancement request has gone unanswered, and a feature-request issue form is open for more.



    The project MUST have a publicly available archive for reports and responses for later searching. (URL required) [report_archive]

    https://github.com/sealandseacat/dbmask/issues?q=is%3Aissue — every report and its responses stay publicly readable and searchable after closing.


  • Vulnerability report process


    The project MUST publish the process for reporting vulnerabilities on the project site. (URL required) [vulnerability_report_process]
    Projects hosted on GitHub SHOULD consider enabling privately reporting a security vulnerability. Projects on GitLab SHOULD consider using its ability for privately reporting a vulnerability. Projects MAY identify a mailing address on https://PROJECTSITE/security, often in the form security@example.org. This vulnerability reporting process MAY be the same as its bug reporting process. Vulnerability reports MAY always be public, but many projects have a private vulnerability reporting mechanism.

    https://github.com/sealandseacat/dbmask/blob/main/SECURITY.md — SECURITY.md documents the reporting process, what counts as a vulnerability for this tool, the supported-versions policy, and what the reporter can expect.



    If private vulnerability reports are supported, the project MUST include how to send the information in a way that is kept private. (URL required) [vulnerability_report_private]
    Examples include a private defect report submitted on the web using HTTPS (TLS) or an email encrypted using OpenPGP. If vulnerability reports are always public (so there are never private vulnerability reports), choose "not applicable" (N/A).

    Private reporting is supported two ways: GitHub private vulnerability reporting is enabled on the repository (https://github.com/sealandseacat/dbmask/security/advisories/new), and SECURITY.md gives a direct email address as a fallback for reporters who cannot use GitHub.



    The project's initial response time for any vulnerability report received in the last 6 months MUST be less than or equal to 14 days. [vulnerability_report_response]
    If there have been no vulnerabilities reported in the last 6 months, choose "not applicable" (N/A).

    One vulnerability has been handled to date. It was found by a safety review of the released 0.1.0, fixed within a day, and disclosed as GHSA-2jwm-hcfc-72xm (Moderate), published on 2026-08-24 alongside the v0.1.1 release that fixes it — far inside the 14-day window. No externally submitted vulnerability reports have been received.


 Quality 13/13

  • Working build system


    If the software produced by the project requires building for use, the project MUST provide a working build system that can automatically rebuild the software from source code. [build]
    A build system determines what actions need to occur to rebuild the software (and in what order), and then performs those steps. For example, it can invoke a compiler to compile the source code. If an executable is created from source code, it must be possible to modify the project's source code and then generate an updated executable with those modifications. If the software produced by the project depends on external libraries, the build system does not need to build those external libraries. If there is no need to build anything to use the software after its source code is modified, select "not applicable" (N/A).

    The project builds with the standard PEP 517 toolchain: python -m build produces the sdist and wheel from source. CI rebuilds both on every push to main and every pull request, validates the metadata with twine check --strict, installs the wheel and smoke-tests the CLI. https://github.com/sealandseacat/dbmask/blob/main/.github/workflows/ci.yml



    It is SUGGESTED that common tools be used for building the software. [build_common_tools]
    For example, Maven, Ant, cmake, the autotools, make, rake (Ruby), or devtools (R).

    setuptools and build — the standard Python packaging tools, configured entirely in pyproject.toml.



    The project SHOULD be buildable using only FLOSS tools. [build_floss_tools]

    The build needs only FLOSS tools: CPython, setuptools, build and twine.


  • Automated test suite


    The project MUST use at least one automated test suite that is publicly released as FLOSS (this test suite may be maintained as a separate FLOSS project). The project MUST clearly show or document how to run the test suite(s) (e.g., via a continuous integration (CI) script or via documentation in files such as BUILD.md, README.md, or CONTRIBUTING.md). [test]
    The project MAY use multiple automated test suites (e.g., one that runs quickly, vs. another that is more thorough but requires special equipment). There are many test frameworks and test support systems available, including Selenium (web browser automation), Junit (JVM, Java), RUnit (R), testthat (R).

    A pytest suite of 121 tests lives in tests/ and is released as FLOSS under the same MIT license as the project. How to run it is documented in CONTRIBUTING.md (pytest) and it is executed by CI on every push to main and every pull request. https://github.com/sealandseacat/dbmask/tree/main/tests



    A test suite SHOULD be invocable in a standard way for that language. [test_invocation]
    For example, "make check", "mvn test", or "rake test" (Ruby).

    pytest — the standard test invocation for a Python project. Configuration lives under [tool.pytest.ini_options] in pyproject.toml.



    It is SUGGESTED that the test suite cover most (or ideally all) the code branches, input fields, and functionality. [test_most]

    Line coverage is 85%, with an 80% floor enforced as a blocking CI job (pytest --cov=dbmask --cov-fail-under=80). The suite exercises the CLI, the detection pipeline, every masking strategy, the seed map and the validation path end to end against throwaway SQLite databases.



    It is SUGGESTED that the project implement continuous integration (where new or changed code is frequently integrated into a central code repository and automated tests are run on the result). [test_continuous_integration]

    GitHub Actions runs on every push to main and every pull request: ruff and mypy, the test matrix (Python 3.9-3.14 on Ubuntu plus Python 3.12 on Windows), the coverage gate, a pip-audit dependency audit, and a packaging build with a wheel smoke test. https://github.com/sealandseacat/dbmask/actions/workflows/ci.yml


  • New functionality testing


    The project MUST have a general policy (formal or not) that as major new functionality is added to the software produced by the project, tests of that functionality should be added to an automated test suite. [test_policy]
    As long as a policy is in place, even by word of mouth, that says developers should add tests to the automated test suite for major new functionality, select "Met."

    CONTRIBUTING.md states it directly: "Every bug fix should come with a regression test that fails on the old code", and "Bug fix -> includes a regression test; feature -> includes tests" is a required checkbox in the pull request template. https://github.com/sealandseacat/dbmask/blob/main/CONTRIBUTING.md#pull-requests



    The project MUST have evidence that the test_policy for adding tests has been adhered to in the most recent major changes to the software produced by the project. [tests_are_added]
    Major functionality would typically be mentioned in the release notes. Perfection is not required, merely evidence that tests are typically being added in practice to the automated test suite when new major functionality is added to the software produced by the project.

    The v0.1.1 release is the evidence: the suite grew from 46 tests at v0.1.0 to 121 at v0.1.1, in the same release that fixed issues #6 to #12 and GHSA-2jwm-hcfc-72xm, with each fix landing alongside a regression test that fails on the 0.1.0 code. https://github.com/sealandseacat/dbmask/blob/main/CHANGELOG.md



    It is SUGGESTED that this policy on adding tests (see test_policy) be documented in the instructions for change proposals. [tests_documented_added]
    However, even an informal rule is acceptable as long as the tests are being added in practice.

    The policy is written in CONTRIBUTING.md and repeated as a checklist item in the pull request template, so contributors see it while proposing a change. https://github.com/sealandseacat/dbmask/blob/main/.github/PULL_REQUEST_TEMPLATE.md


  • Warning flags


    The project MUST enable one or more compiler warning flags, a "safe" language mode, or use a separate "linter" tool to look for code quality errors or common simple mistakes, if there is at least one FLOSS tool that can implement this criterion in the selected language. [warnings]
    Examples of compiler warning flags include gcc/clang "-Wall". Examples of a "safe" language mode include JavaScript "use strict" and perl5's "use warnings". A separate "linter" tool is simply a tool that examines the source code to look for code quality errors or common simple mistakes. These are typically enabled within the source code or build instructions.

    ruff (rule sets E, F, W, I, B, UP) and mypy both run as a blocking CI job on every push to main and every pull request; configuration is in pyproject.toml. https://github.com/sealandseacat/dbmask/blob/main/.github/workflows/ci.yml



    The project MUST address warnings. [warnings_fixed]
    These are the warnings identified by the implementation of the warnings criterion. The project should fix warnings or mark them in the source code as false positives. Ideally there would be no warnings, but a project MAY accept some warnings (typically less than 1 warning per 100 lines or less than 10 warnings).

    The lint job is blocking, so main stays ruff-clean and mypy-clean; a pull request that introduces a warning cannot go green. Both were verified clean at the current head of main.



    It is SUGGESTED that projects be maximally strict with warnings in the software produced by the project, where practical. [warnings_strict]
    Some warnings cannot be effectively enabled on some projects. What is needed is evidence that the project is striving to enable warning flags where it can, so that errors are detected early.

    Not maximally strict yet: mypy does not run in --strict mode, and three ruff rules are deliberately disabled (E501 for unwrapped documentation tables, UP007 and UP045 to keep Optional[X] spelling while Python 3.9 is supported). Tightening both is on the roadmap once the 3.9 floor is dropped.


 Security 16/16

  • Secure development knowledge


    The project MUST have at least one primary developer who knows how to design secure software. (See ‘details’ for the exact requirements.) [know_secure_design]
    This requires understanding the following design principles, including the 8 principles from Saltzer and Schroeder:
    • economy of mechanism (keep the design as simple and small as practical, e.g., by adopting sweeping simplifications)
    • fail-safe defaults (access decisions should deny by default, and projects' installation should be secure by default)
    • complete mediation (every access that might be limited must be checked for authority and be non-bypassable)
    • open design (security mechanisms should not depend on attacker ignorance of its design, but instead on more easily protected and changed information like keys and passwords)
    • separation of privilege (ideally, access to important objects should depend on more than one condition, so that defeating one protection system won't enable complete access. E.G., multi-factor authentication, such as requiring both a password and a hardware token, is stronger than single-factor authentication)
    • least privilege (processes should operate with the least privilege necessary)
    • least common mechanism (the design should minimize the mechanisms common to more than one user and depended on by all users, e.g., directories for temporary files)
    • psychological acceptability (the human interface must be designed for ease of use - designing for "least astonishment" can help)
    • limited attack surface (the attack surface - the set of the different points where an attacker can try to enter or extract data - should be limited)
    • input validation with allowlists (inputs should typically be checked to determine if they are valid before they are accepted; this validation should use allowlists (which only accept known-good values), not denylists (which attempt to list known-bad values)).
    A "primary developer" in a project is anyone who is familiar with the project's code base, is comfortable making changes to it, and is acknowledged as such by most other participants in the project. A primary developer would typically make a number of contributions over the past year (via code, documentation, or answering questions). Developers would typically be considered primary developers if they initiated the project (and have not left the project more than three years ago), have the option of receiving information on a private vulnerability reporting channel (if there is one), can accept commits on behalf of the project, or perform final releases of the project software. If there is only one developer, that individual is the primary developer. Many books and courses are available to help you understand how to develop more secure software and discuss design. For example, the Secure Software Development Fundamentals course is a free set of three courses that explain how to develop more secure software (it's free if you audit it; for an extra fee you can earn a certificate to prove you learned the material).

    The project's sole primary developer designs to the Saltzer-Schroeder principles, and 0.1.1 was an explicit application of them. Fail-safe defaults: a run without --apply is now forced to dry-run regardless of configuration, and masking aborts when the scan could not analyze every column rather than silently leaving it unmasked. Open design: the seed map never stores original values, only a salted SHA-256 digest of each original beside its masked replacement, and the full threat model — including what dbmask does not defend against, and the fact that a generated salt lives in the store alongside it unless the operator supplies one from the environment — is published at https://sealandseacat.github.io/dbmask/security-model/. Least privilege and limited attack surface: a local CLI with no network service; the LLM path is opt-in, warns before any value leaves the machine, and supports a metadata-only mode that sends column names alone. Input validation with allowlists: detection works from explicit pattern and override allowlists, and all SQL is built through SQLAlchemy Core with bound parameters. Economy of mechanism: one SQLAlchemy code path serves every supported dialect.



    At least one of the project's primary developers MUST know of common kinds of errors that lead to vulnerabilities in this kind of software, as well as at least one method to counter or mitigate each of them. [know_common_errors]
    Examples (depending on the type of software) include SQL injection, OS injection, classic buffer overflow, cross-site scripting, missing authentication, and missing authorization. See the CWE/SANS top 25 or OWASP Top 10 for commonly used lists. Many books and courses are available to help you understand how to develop more secure software and discuss common implementation errors that lead to vulnerabilities. For example, the Secure Software Development Fundamentals course is a free set of three courses that explain how to develop more secure software (it's free if you audit it; for an extra fee you can earn a certificate to prove you learned the material).

    SQL injection: every statement is built through SQLAlchemy Core with bound parameters, never string interpolation of configuration values. Credential leakage: database URLs and the seed-map salt are supplied through environment variables and kept out of the repository, with GitHub secret scanning and push protection enabled and PyPI publishing done over OIDC so no long-lived token exists. Sensitive data in logs: previews redact original values by default behind an explicit --show-values opt-in. And the failure mode specific to this class of tool, reporting data as masked when it was not, is countered by the row-level validate step plus the 0.1.1 fixes for silently skipped primary-key columns and fail-open scans. https://sealandseacat.github.io/dbmask/security-model/


  • Use basic good cryptographic practices

    Note that some software does not need to use cryptographic mechanisms. If your project produces software that (1) includes, activates, or enables encryption functionality, and (2) might be released from the United States (US) to outside the US or to a non-US-citizen, you may be legally required to take a few extra steps. Typically this just involves sending an email. For more information, see the encryption section of Understanding Open Source Technology & US Export Controls.

    The software produced by the project MUST use, by default, only cryptographic protocols and algorithms that are publicly published and reviewed by experts (if cryptographic protocols and algorithms are used). [crypto_published]
    These cryptographic criteria do not always apply because some software has no need to directly use cryptographic capabilities.

    SHA-256 (FIPS 180-4) is the only cryptographic algorithm used, through Python's standard-library hashlib: masking randomness is derived from sha256(seed:value) and seed-map entries are keyed on salted SHA-256 digests. No custom or unpublished construction anywhere.



    If the software produced by the project is an application or library, and its primary purpose is not to implement cryptography, then it SHOULD only call on software specifically designed to implement cryptographic functions; it SHOULD NOT re-implement its own. [crypto_call]

    The project calls CPython's standard library (hashlib, secrets) and re-implements nothing cryptographic itself.



    All functionality in the software produced by the project that depends on cryptography MUST be implementable using FLOSS. [crypto_floss]

    Everything cryptographic runs on CPython's hashlib (OpenSSL-backed) and secrets (the OS CSPRNG) — both FLOSS.



    The security mechanisms within the software produced by the project MUST use default keylengths that at least meet the NIST minimum requirements through the year 2030 (as stated in 2012). It MUST be possible to configure the software so that smaller keylengths are completely disabled. [crypto_keylength]
    These minimum bitlengths are: symmetric key 112, factoring modulus 2048, discrete logarithm key 224, discrete logarithmic group 2048, elliptic curve 224, and hash 224 (password hashing is not covered by this bitlength, more information on password hashing can be found in the crypto_password_storage criterion). See https://www.keylength.com for a comparison of keylength recommendations from various organizations. The software MAY allow smaller keylengths in some configurations (ideally it would not, since this allows downgrade attacks, but shorter keylengths are sometimes necessary for interoperability).

    Digests are SHA-256 at 256 bits, above the NIST-through-2030 hash minimum of 224 bits, and the algorithm is not configurable. When the operator supplies no seed-map salt, dbmask generates one of 128 bits with secrets.token_hex(16). An operator-supplied salt and the masking seed are free-form secrets whose strength is the operator's choice; the CLI warns when the seed is left at the publicly known default, and the documentation tells operators to supply both from the environment.



    The default security mechanisms within the software produced by the project MUST NOT depend on broken cryptographic algorithms (e.g., MD4, MD5, single DES, RC4, Dual_EC_DRBG), or use cipher modes that are inappropriate to the context, unless they are necessary to implement an interoperable protocol (where the protocol implemented is the most recent version of that standard broadly supported by the network ecosystem, that ecosystem requires the use of such an algorithm or mode, and that ecosystem does not offer any more secure alternative). The documentation MUST describe any relevant security risks and any known mitigations if these broken algorithms or modes are necessary for an interoperable protocol. [crypto_working]
    ECB mode is almost never appropriate because it reveals identical blocks within the ciphertext as demonstrated by the ECB penguin, and CTR mode is often inappropriate because it does not perform authentication and causes duplicates if the input state is repeated. In many cases it's best to choose a block cipher algorithm mode designed to combine secrecy and authentication, e.g., Galois/Counter Mode (GCM) and EAX. Projects MAY allow users to enable broken mechanisms (e.g., during configuration) where necessary for compatibility, but then users know they're doing it.

    No MD4, MD5, SHA-1, single DES or RC4 appears anywhere in the codebase; SHA-256 is the only hash in use and there is no cipher mode to choose.



    The default security mechanisms within the software produced by the project SHOULD NOT depend on cryptographic algorithms or modes with known serious weaknesses (e.g., the SHA-1 cryptographic hash algorithm or the CBC mode in SSH). [crypto_weaknesses]
    Concerns about CBC mode in SSH are discussed in CERT: SSH CBC vulnerability.

    No algorithm with a known serious weakness is used. There is no SHA-1 and no block-cipher mode selection in the project.



    The security mechanisms within the software produced by the project SHOULD implement perfect forward secrecy for key agreement protocols so a session key derived from a set of long-term keys cannot be compromised if one of the long-term keys is compromised in the future. [crypto_pfs]

    dbmask implements no network protocol and no key-agreement protocol. Transport security for database connections and optional LLM API calls is provided by the underlying drivers and HTTP client (TLS), not by this project.



    If the software produced by the project causes the storing of passwords for authentication of external users, the passwords MUST be stored as iterated hashes with a per-user salt by using a key stretching (iterated) algorithm (e.g., Argon2id, Bcrypt, Scrypt, or PBKDF2). See also OWASP Password Storage Cheat Sheet. [crypto_password_storage]
    This criterion applies only when the software is enforcing authentication of users using passwords for external users (aka inbound authentication), such as server-side web applications. It does not apply in cases where the software stores passwords for authenticating into other systems (aka outbound authentication, e.g., the software implements a client for some other system), since at least parts of that software must have often access to the unhashed password.

    dbmask does not authenticate external users and stores no passwords. Database credentials are supplied by the operator through configuration or environment variables and handed straight to the driver.



    The security mechanisms within the software produced by the project MUST generate all cryptographic keys and nonces using a cryptographically secure random number generator, and MUST NOT do so using generators that are cryptographically insecure. [crypto_random]
    A cryptographically secure random number generator may be a hardware random number generator, or it may be a cryptographically secure pseudo-random number generator (CSPRNG) using an algorithm such as Hash_DRBG, HMAC_DRBG, CTR_DRBG, Yarrow, or Fortuna. Examples of calls to secure random number generators include Java's java.security.SecureRandom and JavaScript's window.crypto.getRandomValues. Examples of calls to insecure random number generators include Java's java.util.Random and JavaScript's Math.random.

    Every value dbmask generates that has to be unguessable comes from a cryptographically secure generator: the seed-map salt, when the operator does not supply one, is secrets.token_hex(16). The per-value random.Random used to produce masked output is deliberately deterministic, seeded from sha256(seed:value) — it is a reproducibility mechanism rather than a source of keys or nonces, and the consequences of that determinism are set out in the published threat model at https://sealandseacat.github.io/dbmask/security-model/.


  • Secured delivery against man-in-the-middle (MITM) attacks


    The project MUST use a delivery mechanism that counters MITM attacks. Using https or ssh+scp is acceptable. [delivery_mitm]
    An even stronger mechanism is releasing the software with digitally signed packages, since that mitigates attacks on the distribution system, but this only works if the users can be confident that the public keys for signatures are correct and if the users will actually check the signature.

    All delivery is over HTTPS: the repository and releases from GitHub, and packages from PyPI, which pip fetches over TLS. Releases are published with PyPI Trusted Publishing (OIDC), so no long-lived API token exists to steal, and the publishing action is pinned to a commit SHA rather than a movable tag.



    A cryptographic hash (e.g., a sha1sum) MUST NOT be retrieved over http and used without checking for a cryptographic signature. [delivery_unsigned]
    These hashes can be modified in transit.

    No hash or checksum is ever retrieved over plain http in the build or install path. pip obtains packages and their hashes from PyPI over TLS.


  • Publicly known vulnerabilities fixed


    There MUST be no unpatched vulnerabilities of medium or higher severity that have been publicly known for more than 60 days. [vulnerabilities_fixed_60_days]
    The vulnerability must be patched and released by the project itself (patches may be developed elsewhere). A vulnerability becomes publicly known (for this purpose) once it has a CVE with publicly released non-paywalled information (reported, for example, in the National Vulnerability Database) or when the project has been informed and the information has been released to the public (possibly by the project). A vulnerability is considered medium or higher severity if its Common Vulnerability Scoring System (CVSS) base qualitative score is medium or higher. In CVSS versions 2.0 through 3.1, this is equivalent to a CVSS score of 4.0 or higher. Projects may use the CVSS score as published in a widely-used vulnerability database (such as the National Vulnerability Database) using the most-recent version of CVSS reported in that database. Projects may instead calculate the severity themselves using the latest version of CVSS at the time of the vulnerability disclosure, if the calculation inputs are publicly revealed once the vulnerability is publicly known. Note: this means that users might be left vulnerable to all attackers worldwide for up to 60 days. This criterion is often much easier to meet than what Google recommends in Rebooting responsible disclosure, because Google recommends that the 60-day period start when the project is notified even if the report is not public. Also note that this badge criterion, like other criteria, applies to the individual project. Some projects are part of larger umbrella organizations or larger projects, possibly in multiple layers, and many projects feed their results to other organizations and projects as part of a potentially-complex supply chain. An individual project often cannot control the rest, but an individual project can work to release a vulnerability patch in a timely way. Therefore, we focus solely on the individual project's response time. Once a patch is available from the individual project, others can determine how to deal with the patch (e.g., they can update to the newer version or they can apply just the patch as a cherry-picked solution).

    One vulnerability has been publicly disclosed for this project, GHSA-2jwm-hcfc-72xm (Moderate), published on 2026-08-24. The fix was already available in v0.1.1, released the same day, so the issue was never publicly known while unpatched. There are no open vulnerabilities. https://github.com/sealandseacat/dbmask/security/advisories/GHSA-2jwm-hcfc-72xm



    Projects SHOULD fix all critical vulnerabilities rapidly after they are reported. [vulnerabilities_critical_fixed]

    The one vulnerability found to date was fixed within a day of being identified and shipped before its advisory was published.


  • Other security issues


    The public repositories MUST NOT leak a valid private credential (e.g., a working password or private key) that is intended to limit public access. [no_leaked_credentials]
    A project MAY leak "sample" credentials for testing and unimportant databases, as long as they are not intended to limit public access.

    No credential is committed anywhere: examples run against throwaway SQLite files and the shipped example configuration uses environment placeholders (${DB_PASSWORD}, ${OPENAI_API_KEY}), with the documentation and SECURITY.md telling operators to supply the seed-map salt the same way (salt: ${DBMASK_SEED_SALT}). GitHub secret scanning and push protection are enabled on the repository, and PyPI publishing uses OIDC rather than a stored token.


 Analysis 8/8

  • Static code analysis


    At least one static code analysis tool (beyond compiler warnings and "safe" language modes) MUST be applied to any proposed major production release of the software before its release, if there is at least one FLOSS tool that implements this criterion in the selected language. [static_analysis]
    A static code analysis tool examines the software code (as source code, intermediate code, or executable) without executing it with specific inputs. For purposes of this criterion, compiler warnings and "safe" language modes do not count as static code analysis tools (these typically avoid deep analysis because speed is vital). Some static analysis tools focus on detecting generic defects, others focus on finding specific kinds of defects (such as vulnerabilities), and some do a combination. Examples of such static code analysis tools include cppcheck (C, C++), clang static analyzer (C, C++), SpotBugs (Java), FindBugs (Java) (including FindSecurityBugs), PMD (Java), Brakeman (Ruby on Rails), lintr (R), goodpractice (R), Coverity Quality Analyzer, SonarQube, Codacy, and HP Enterprise Fortify Static Code Analyzer. Larger lists of tools can be found in places such as the Wikipedia list of tools for static code analysis, OWASP information on static code analysis, NIST list of source code security analyzers, and Wheeler's list of static analysis tools. If there are no FLOSS static analysis tools available for the implementation language(s) used, you may select 'N/A'.

    CodeQL (github/codeql-action) analyzes the Python source on every push to main, on every pull request targeting main, and weekly on a schedule; results are uploaded to GitHub code scanning and reviewed before a release is cut. ruff and mypy run on pushes to main and on pull requests as blocking jobs. Two warning-level CodeQL alerts raised during the 0.1.1 work were fixed before that release shipped (commit "fix(security): resolve both CodeQL warning-level alerts"). https://github.com/sealandseacat/dbmask/actions/workflows/codeql.yml



    It is SUGGESTED that at least one of the static analysis tools used for the static_analysis criterion include rules or approaches to look for common vulnerabilities in the analyzed language or environment. [static_analysis_common_vulnerabilities]
    Static analysis tools that are specifically designed to look for common vulnerabilities are more likely to find them. That said, using any static tools will typically help find some problems, so we are suggesting but not requiring this for the 'passing' level badge.

    CodeQL's Python analysis includes its security query suite, which looks for injection, path traversal, unsafe deserialization and similar common vulnerability classes.



    All medium and higher severity exploitable vulnerabilities discovered with static code analysis MUST be fixed in a timely way after they are confirmed. [static_analysis_fixed]
    A vulnerability is considered medium or higher severity if its Common Vulnerability Scoring System (CVSS) base qualitative score is medium or higher. In CVSS versions 2.0 through 3.1, this is equivalent to a CVSS score of 4.0 or higher. Projects may use the CVSS score as published in a widely-used vulnerability database (such as the National Vulnerability Database) using the most-recent version of CVSS reported in that database. Projects may instead calculate the severity themselves using the latest version of CVSS at the time of the vulnerability disclosure, if the calculation inputs are publicly revealed once the vulnerability is publicly known. Note that criterion vulnerabilities_fixed_60_days requires that all such vulnerabilities be fixed within 60 days of being made public.

    No exploitable vulnerability of medium or higher severity has been reported by static analysis. The two warning-level CodeQL alerts raised during the v0.1.1 work were fixed before that release shipped. The alerts open today are all note-level results from CodeQL's code-quality suite (py/should-use-with — a readability recommendation to replace a try/finally that only closes a resource with a with statement); none of them is a security finding.



    It is SUGGESTED that static source code analysis occur on every commit or at least daily. [static_analysis_often]

    On every push to main, on every pull request, and on a weekly schedule.


  • Dynamic code analysis


    It is SUGGESTED that at least one dynamic analysis tool be applied to any proposed major production release of the software before its release. [dynamic_analysis]
    A dynamic analysis tool examines the software by executing it with specific inputs. For example, the project MAY use a fuzzing tool (e.g., American Fuzzy Lop) or a web application scanner (e.g., OWASP ZAP or w3af). In some cases the OSS-Fuzz project may be willing to apply fuzz testing to your project. For purposes of this criterion the dynamic analysis tool needs to vary the inputs in some way to look for various kinds of problems or be an automated test suite with at least 80% branch coverage. The Wikipedia page on dynamic analysis and the OWASP page on fuzzing identify some dynamic analysis tools. The analysis tool(s) MAY be focused on looking for security vulnerabilities, but this is not required.

    The pytest suite is the dynamic analysis: 121 tests execute the tool end to end against real SQLite databases, varying column types, values and configurations. Measured with pytest --cov-branch, branch coverage is 84% (456 of 544 branches), above the 80% bar, and a coverage floor runs as a blocking CI job before any release is cut.



    It is SUGGESTED that if the software produced by the project includes software written using a memory-unsafe language (e.g., C or C++), then at least one dynamic tool (e.g., a fuzzer or web application scanner) be routinely used in combination with a mechanism to detect memory safety problems such as buffer overwrites. If the project does not produce software written in a memory-unsafe language, choose "not applicable" (N/A). [dynamic_analysis_unsafe]
    Examples of mechanisms to detect memory safety problems include Address Sanitizer (ASAN) (available in GCC and LLVM), Memory Sanitizer, and valgrind. Other potentially-used tools include thread sanitizer and undefined behavior sanitizer. Widespread assertions would also work.

    The project is pure Python; it contains no code written in a memory-unsafe language.



    It is SUGGESTED that the project use a configuration for at least some dynamic analysis (such as testing or fuzzing) which enables many assertions. In many cases these assertions should not be enabled in production builds. [dynamic_analysis_enable_assertions]
    This criterion does not suggest enabling assertions during production; that is entirely up to the project and its users to decide. This criterion's focus is instead to improve fault detection during dynamic analysis before deployment. Enabling assertions in production use is completely different from enabling assertions during dynamic analysis (such as testing). In some cases enabling assertions in production use is extremely unwise (especially in high-integrity components). There are many arguments against enabling assertions in production, e.g., libraries should not crash callers, their presence may cause rejection by app stores, and/or activating an assertion in production may expose private data such as private keys. Beware that in many Linux distributions NDEBUG is not defined, so C/C++ assert() will by default be enabled for production in those environments. It may be important to use a different assertion mechanism or defining NDEBUG for production in those environments.

    The suite runs on pytest, whose assertion rewriting keeps every assertion active and reports the intermediate values on failure, and tests are never run under python -O, so Python's own assert statements stay enabled during analysis.



    All medium and higher severity exploitable vulnerabilities discovered with dynamic code analysis MUST be fixed in a timely way after they are confirmed. [dynamic_analysis_fixed]
    If you are not running dynamic code analysis and thus have not found any vulnerabilities in this way, choose "not applicable" (N/A). A vulnerability is considered medium or higher severity if its Common Vulnerability Scoring System (CVSS) base qualitative score is medium or higher. In CVSS versions 2.0 through 3.1, this is equivalent to a CVSS score of 4.0 or higher. Projects may use the CVSS score as published in a widely-used vulnerability database (such as the National Vulnerability Database) using the most-recent version of CVSS reported in that database. Projects may instead calculate the severity themselves using the latest version of CVSS at the time of the vulnerability disclosure, if the calculation inputs are publicly revealed once the vulnerability is publicly known.

    No medium or higher severity exploitable vulnerability has been found by dynamic analysis. The test suite is a blocking check, so failures are fixed before a change can merge.



You can use tools and AI systems to propose changes via a simple URL, such as https://www.bestpractices.dev/en/projects/14225/choose/edit?osps_ac_01_01_status=Met&osps_ac_01_01_justification=GitHub+enforced. See our automation proposals system for how to do that. This data is available under the Community Data License Agreement – Permissive, Version 2.0 (CDLA-Permissive-2.0). This means that a Data Recipient may share the Data, with or without modifications, so long as the Data Recipient makes available the text of this agreement with the shared Data. Please credit Siyuan Feng and the OpenSSF Best Practices badge contributors.

Project badge entry owned by: Siyuan Feng.
Entry created on 2026-08-24 19:27:49 UTC, last updated on 2026-08-24 20:31:21 UTC. Last achieved passing badge on 2026-08-24 20:31:21 UTC.