Queryable Encryption
Queryable Encryption: free step-by-step lesson with examples, common mistakes, and interview tips — part of MongoDB Tutorial on Toolliyo Academy.
On this page
MongoDB Tutorial · Lesson 85 of 100
Queryable Encryption
Foundations & CRUD ✓ → Queries & Schema ✓ → Aggregation & Scale ✓ → Atlas & Projects
Atlas & Projects · 4 — Build · ~10 min · MongoDB — Modern Features
What is this?
Queryable Encryption (QE) encrypts sensitive fields while still allowing equality (and more, depending on configuration) queries on ciphertext using encrypted indexes — stronger than storing opaque blobs you cannot search.
Why should you care?
Fraud and support still need to look up a customer by encrypted phone/email without exposing plaintext to the database server.
See it live — copy this example
Open mongosh or MongoDB Compass, select database nosqlverse, then run the example. Change one field and run again.
// Conceptual workflow (driver + crypt shared library + KMS)
// 1) Create encrypted fields map for users.phone
// 2) Auto-encryption MongoClient encrypts on write / decrypts on read
// 3) Queries look normal in app code:
db.users.insertOne({ email: "a@x.com", phone: "9999999999" })
db.users.find({ phone: "9999999999" })
// On disk / in mongosh without keys you see binary ciphertext, not the phone
Run Example »
Edit the code below and click Run to see the result in Toolliyo’s live editor.
What happened?
- The driver encrypts phone before the server sees it.
- Encrypted indexes make equality find work.
- Without keys, admins see BinData.
- Setup needs KMS, schema map, and the crypt shared library — follow current Atlas QE docs for your version.
Practice next
- Read Atlas Queryable Encryption quick start for your language.
- Classify one field (phone) for QE in a sandbox.
- Insert and find by phone through the encrypting client.
- Add email as a second encrypted field.
- Compare CSFLE vs QE capabilities for your needs.
Remember
QE encrypts fields but keeps some queries working. Keys live in KMS, not in Mongo documents. Use for high-sensitivity lookup fields.
Lookup by encrypted mobile
Support finds accounts by phone without the DB storing plaintext mobiles.
Outcome: Breach of disk backups does not leak raw phone numbers.
Interview prep for this lesson
Practice these questions aloud after reading—each links to a full structured answer.
Sign in to ask a question or upvote helpful answers.
No questions yet — be the first to ask!