Text-to-query वर्कफ़्लो

MongoDB और LangGraph के साथ Text-to-Query Agents

Apoorva Joshi

Senior AI/ML Developer Advocate, MongoDB

Text-to-query

Text-to-query

Text-to-query

Text-to-query

Text-to-query

Text-to-query

Text-to-query: एजेंटिक अप्रोच

 

Data: MongoDB तरीका!

 

Structured Query Language (SQL)

उदाहरण SQL क्वेरी

SELECT *
FROM table
WHERE year>=1950
LIMIT 5

MongoDB Query API

उदाहरण JSON-जैसा इनपुट

{ "$and": [
              {"year": {"$gte": 1990}},
              {"year": {"$lt": 2000}}
          ]
}

MongoDB क्वेरी मेथड्स

• .find(), .insert(), .update(), .delete()

उदाहरण: movies कलेक्शन

_id	Title	Release Year	Cast	Genres
573a1396f29313caabce3d17	Larks on a String	1990	[Rudolf Hrusènskè, Vlastimil Brodskè]	[Comedy, Drama, Romance]
573a1398f29313caabceab72	The Witching of Ben Wagner	1990	[Sam Bottoms, Harriet Hall, Bettina Rae, Justin Gocke]	[Family]
...	...	...	[...]	[...]

सिंगल फ़िल्टर्स

query = {"genre": "Romance"}

सिंगल फ़िल्टर्स

query = {"genre": "Romance"}

_id	Title	Release Year	Cast	Genres
573a1390f29313caabcd6377	Wild and Woolly	1917	[Douglas Fairbanks, Eileen Percy, Calvert Carter, Charles Stevens]	[Comedy, Western, Romance]
573a1391f29313caabcd70b4	The Four Horsemen of the Apocalypse	1921	[Pomeroy Cannon, Josef Swickard, Bridgetta Clark, Rudolph Valentino]	[Drama, Romance, War]

मल्टिपल फ़िल्टर्स

query = { "$and": [
                    {"year": {"$gte": 1990}},
                    {"year": {"$lt": 2000}}
                  ]
        }

मल्टिपल फ़िल्टर्स

query = { "$and": [
                    {"year": {"$gte": 1990}},
                    {"year": {"$lt": 2000}}
                  ]
        }

_id	Title	Release Year	Cast	Genres
573a1396f29313caabce3d17	Larks on a String	1990	[Rudolf Hrusènskè, Vlastimil Brodskè]	[Comedy, Drama, Romance]
573a1398f29313caabceab72	The Witching of Ben Wagner	1990	[Sam Bottoms, Harriet Hall, Bettina Rae, Justin Gocke]	[Family]

एग्रीगेशन पाइपलाइन्स

db.<collection>.aggregate([
    {stage-1},
    {stage-2},
    {stage-3},
    {stage-4},
])

मल्टिपल ऑपरेशंस

query = [








]

मल्टिपल ऑपरेशंस

query = [

    { "$sort": { "released": -1 } },






]

• released के अनुसार sort

मल्टिपल ऑपरेशंस

query = [

    { "$sort": { "released": -1 } },

    { "$limit": 5 },




]

• released के अनुसार sort

• परिणाम 5 तक limit

मल्टिपल ऑपरेशंस

query = [

    { "$sort": { "released": -1 } },

    { "$limit": 5 },

    { "$project": { "title": 1,
                    "_id": 0 } }

]

• released के अनुसार sort

• परिणाम 5 तक limit

• "title" कॉलम project

मल्टिपल ऑपरेशंस

query = [

    { "$sort": { "released": -1 } },

    { "$limit": 5 },

    { "$project": { "title": 1,
                    "_id": 0 } }

]

• released के अनुसार sort

• परिणाम 5 तक limit

• "title" कॉलम project

Title
The Treasure
Knight of Cups
Sand Castles
Shut In
Dègradè

ग्रुप्ड एग्रीगेशंस

_id	Title	Release Year	Cast	Genres
573a1396f29313caabce3d17	Larks on a String	1990	[Rudolf Hrusènskè, Vlastimil Brodskè]	[Comedy, Drama, Romance]
573a1398f29313caabceab72	The Witching of Ben Wagner	1990	[Sam Bottoms, Harriet Hall, Bettina Rae, Justin Gocke]	[Family]
...	...	...	[...]	[...]

ग्रुप्ड एग्रीगेशंस

query = [

          { "$unwind": "$genres" },

          { "$group": {
                "_id": "$genres",
                "numMovies": { "$sum": 1 }
          }},

          { "$match": { "numMovies": { "$gte": 50 } } }

]

ग्रुप्ड एग्रीगेशंस

 

Genre	Count
Drama	12385
Comedy	6532
Romance	3318
Crime	2457
Thriller	2454
...	...

पाइपलाइन स्टेजेज़

• $match, $group, $facet, $geoNear, $lookup, $merge, $search, $sort...

ऑपरेटर्स

• Comparison: $eq, $gt, $gte, ...
• Math: $add, $multiply, $divide...
• Array: $push, $reduce, ...
• String: $toUpper, $toLower, ...
• Temporal: $dateAdd, $dateDiff, ...

अभ्यास करते हैं!

MongoDB और LangGraph के साथ Text-to-Query Agents