Phisql is an optional add-on to Philter that lets you find sensitive information, such as PII and PHI, in your structured data. With Phisql you can query your data using a familiar SQL-like interface to find and redact sensitive information.

To get started using Phisql, contact us about enabling the Phisql add-on for Philter and we will get you set up!

With Phisql you can:

  • Redact, replace, anonymize, or encrypt the PHI, PII, and other sensitive information in structured and unstructured data.
  • Use a SQL-like syntax for identifying and redacting sensitive information.
  • Get more control over your sensitive information!

Here are some ways in which you can use Phisql to identify and redact sensitive information:

  • SELECT names, ages FROM my-structured-data.csv
  • UPDATE my-structured-data.csv SET names REDACTED(name)

Using these SQL-like statements, you can find and redact sensitive information in your data. Phisql will transform your statement into actions to find the given types of sensitive information, and redact the sensitive information. These are just two examples of how Phisql can be used – there are many possibilities!