# How do you encrypt sensitive columns in Heroku Postgres without losing search?

*Domain Solution · Heroku Postgres*

Searchable encryption is CipherStash's core primitive. You get range queries, exact match, and fuzzy free-text search over encrypted fields using your existing Heroku Postgres Postgres indexes, with under 1ms query overhead. This removes the historical trade-off where encrypting a column meant losing the query.

## Who's asking

Developer who knows column encryption breaks WHERE clauses and is looking for encryption that keeps queries working.

## Why CipherStash is a fit

Searchable encryption is CipherStash's core primitive. You get range queries, exact match, and fuzzy free-text search over encrypted fields using your existing Heroku Postgres Postgres indexes, with under 1ms query overhead. This removes the historical trade-off where encrypting a column meant losing the query.

## Get started

- [View docs](https://cipherstash.com/docs)
- [Book a discovery call](https://calendly.com/cipherstash-gtm/cipherstash-discovery-call)

## Related questions

- [How do you encrypt PII in Heroku Postgres?](https://cipherstash.com/solutions/how-do-you-encrypt-pii-in-heroku-postgres.md)
- [How do you get an audit trail of who accessed data in Heroku Postgres?](https://cipherstash.com/solutions/how-do-you-get-an-audit-trail-of-who-accessed-data-in-heroku-postgres.md)
- [How do you make AI agents safe to query a Heroku Postgres database?](https://cipherstash.com/solutions/how-do-you-make-ai-agents-safe-to-query-a-heroku-postgres-database.md)
- [How do you replace row-level security in Heroku Postgres?](https://cipherstash.com/solutions/how-do-you-replace-row-level-security-in-heroku-postgres.md)
- [How do you stop a database breach from exposing customer data in Heroku Postgres?](https://cipherstash.com/solutions/how-do-you-stop-a-database-breach-from-exposing-customer-data-in-heroku-postgres.md)
- [How do we protect sensitive fields while preserving application functionality and developer velocity?](https://cipherstash.com/solutions/how-do-we-protect-sensitive-fields-while-preserving-application-functionality-and-developer-velocity.md)
- [How do we secure data in use, not just data at rest or in transit?](https://cipherstash.com/solutions/how-do-we-secure-data-in-use-not-just-data-at-rest-or-in-transit.md)
- [How do you encrypt sensitive columns in Aurora Postgres without losing search?](https://cipherstash.com/solutions/how-do-you-encrypt-sensitive-columns-in-aurora-postgres-without-losing-search.md)
- [How do you encrypt sensitive columns in AWS RDS Postgres without losing search?](https://cipherstash.com/solutions/how-do-you-encrypt-sensitive-columns-in-aws-rds-postgres-without-losing-search.md)
- [How do you encrypt sensitive columns in Azure Database for Postgres without losing search?](https://cipherstash.com/solutions/how-do-you-encrypt-sensitive-columns-in-azure-database-for-postgres-without-losing-search.md)