PII Catcher

Overview

PiiCatcher finds PII data in your databases anbd files. It finds the following types of PII information:

PHONE
EMAIL
CREDIT_CARD
ADDRESS
PERSON
LOCATION
BIRTH_DATE
GENDER
NATIONALITY
IP_ADDRESS
SSN
USER_NAME
PASSWORD

PiiCatcher uses three types of scanners to detect PII information:

CommonRegex uses a set of regular expressions for common types of information
Spacy Named Entity Recognition uses Natural Language Processing to detect named entities. Only English language is currently supported.
Column Name Scanner scan the name of the column for common names given to columns containing PII data.

Supported Technologies

PiiCatcher supports the following filesystems:

POSIX
AWS S3 (for files that are part of tables in AWS Glue and AWS Athena)
Google Cloud Storage (Coming Soon)
ADLS (Coming Soon)

PiiCatcher supports the following databases:

Sqlite3 v3.24.0 or greater
MySQL 5.6 or greater
PostgreSQL 9.4 or greater
AWS Redshift
SQL Server
Oracle
AWS Glue/AWS Athena

Example

# run piicatcher on a sqlite db and print report to console
piicatcher db -c '/db/sqlqb'
╭─────────────┬─────────────┬─────────────┬─────────────╮
│   schema    │    table    │   column    │   has_pii   │
├─────────────┼─────────────┼─────────────┼─────────────┤
│        main │    full_pii │           a │           1 │
│        main │    full_pii │           b │           1 │
│        main │      no_pii │           a │           0 │
│        main │      no_pii │           b │           0 │
│        main │ partial_pii │           a │           1 │
│        main │ partial_pii │           b │           0 │
╰─────────────┴─────────────┴─────────────┴─────────────╯

Introduction

Installation