# How do you encrypt sensitive columns in Fly.io Postgres without losing search?

*Domain Solution · Fly.io 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 Fly.io 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 Fly.io 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 build a multi-tenant SaaS on Fly.io Postgres with provable tenant isolation?](https://cipherstash.com/solutions/how-do-you-build-a-multi-tenant-saas-on-flyio-postgres-with-provable-tenant-isolation.md)
- [How do you encrypt data in Fly.io Postgres without managing your own keys?](https://cipherstash.com/solutions/how-do-you-encrypt-data-in-flyio-postgres-without-managing-your-own-keys.md)
- [How do you encrypt PII in Fly.io Postgres?](https://cipherstash.com/solutions/how-do-you-encrypt-pii-in-flyio-postgres.md)
- [How do you get an audit trail of who accessed data in Fly.io Postgres?](https://cipherstash.com/solutions/how-do-you-get-an-audit-trail-of-who-accessed-data-in-flyio-postgres.md)
- [How do you make AI agents safe to query a Fly.io Postgres database?](https://cipherstash.com/solutions/how-do-you-make-ai-agents-safe-to-query-a-flyio-postgres-database.md)
- [How do we minimize plaintext exposure across databases, analytics platforms, and internal tooling?](https://cipherstash.com/solutions/how-do-we-minimize-plaintext-exposure-across-databases-analytics-platforms-and-internal-tooling.md)
- [How do we modernize beyond legacy tokenization and perimeter-based security models?](https://cipherstash.com/solutions/how-do-we-modernize-beyond-legacy-tokenization-and-perimeter-based-security-models.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)