Dbmask
Discover, mask, and verify sensitive data in SQL databases
Get picks like this daily. Today's launch numbers, the top launches, AI and tech news, and a daily opportunity pick, straight to your inbox.
Want to reach these readers? Sponsor an issue.
Hi HNI developed *dbmask*, an open-source Python tool designed to discover sensitive columns in SQL databases, masking them with deterministic fake values, and validate the masking results.The motivation behind this tool stems from a common issue I encountered when handling test data: existing masking tools often assume the user already knows exactly which columns contain sensitive information. Furthermore, the successful completion of a masking task does not guarantee that all sensitive values have actually been replaced.dbmask aims to integrate these steps into a unified workflow rather than treating them as three separate tasks.During the detection phase, the tool makes determinations by combining column names, sampled values, database type/context, historical decisions, and optionally LLMs. While LLM functionality is disabled by default, it supports local execution via Ollama or other services compatible with the OpenAI API. If the tool cannot determine a column's nature with confidence, it marks it as `UNKNOWN` rather than simply classifying uncertain cases as "non-sensitive."I also wanted to incorporate human decision-making into the system. Detection results can be exported for manual review, and confirmed decisions can be saved in CSV, XLSX, or Markdown formats, or stored in a SQL history decision table. The system logs information about both the analyst and the reviewer and re-evaluates past decisions if column types change or review results expire.The masking process employs deterministic mapping, ensuring that identical original values consistently map to the same synthetic values across different tables. Once masking is complete, the `dbmask validate --strict` command compares the masked copy with the original data, checking row counts and table structures, and verifying sensitive values row-by-row using primary keys wherever possible.The project is currently in its early stages (version 0.1.x). The current CI (Continuous Integration) pipeline covers SQLite testing; integration tests for PostgreSQL and MySQL, as well as public detection benchmarks, are included in the future development roadmap.I would particularly appreciate feedback on the detection rules, the manual review/history tracking workflows, and the verification methods. Please let me know if you encounter any usability issues or potential security risks while testing on the temporary database.Install:pip install dbmask
HN · launched Sep 10, 2026 · 5 upvotes (top 87%) · 0 views
Niche: enterprise data privacy and anonymization software · 54 launches, 3 in the last 7 days · Explore this niche →
Category and tags
- Horizontal
- Compliance & governance
- B2B
- Not AI
- Commercial product
Visit website ↗ Source listing ↗
More like this: all 54 launches in enterprise data privacy and anonymization software →
Could you build this?
Yes Dbmask is a Python database scanning and masking CLI/tool that introspects schema metadata, identifies PII using regex/heuristics, and masks values deterministically (e.g. using Faker/hashlib).
Discussion
No comments on this launch.
Competitors
Other products that read as similar to this one : 230 launches clear the similarity bar, closest 8 shown.
Attention rank: #181 of 231 (itself plus its competitors, highest first, normalized so YC and Product Hunt are compared fairly).
Launched 316 days after the earliest competitor.
- pgfake · github · 2026-10-06 · 33 upvotes · similarity 0.51
- Automatic deduction of FlashAttention kernel from ~25 lines of SQL · hn · 2026-10-30 · 28 upvotes · similarity 0.47
- DataMask · ph · 2026-09-19 · 1 upvotes · similarity 0.47
- Zingle · hn · 2025-11-14 · 9 upvotes · similarity 0.44
- TypeGraph · hn · 2026-02-24 · 5 upvotes · similarity 0.43
- ShapedQL · hn · 2026-01-27 · 80 upvotes · similarity 0.43
- rmBug · hn · 2026-04-01 · 14 upvotes · similarity 0.43
- Kairos · hn · 2026-11-03 · 104 upvotes · similarity 0.43
The niche, labels, vibe code rating and competitor comparison on this page are analysis by Nicheloom. If you use them, please credit nicheloom.com. How you may use our data.