KO | EN

GitLite

Minimalist Open Source Repository Search Engine

gitlite — search

#dsh #dsh-plugin #ai-agents #developer-tools #codex #claude-code #mcp #rust #deepseek-harness #typescript #ai-agent #cli

mongo-to-sql-converter

★ 40 Open GitHub ↗

This is simple tool to convert mongo query to SQL

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# mongo-to-sql-converter
This is simple tool to convert MongoDB query (```find()```) to SQL

The package takes string as input and gives string as output. It supports only _db.find_ method and throws an exception when another method used.

## Getting Started

### Installing

```
npm i mongo-to-sql-converter
```

### Usage

```
var mongoToSqlConverter = require("mongo-to-sql-converter")

const MongoDBQuery = "db.user.find({age: {$gte: 21}, name: 'julio', contribs: { $in: [ 'ALGOL', 'Lisp' ]}},{name: 1, _id: 1});"
const SQLQuery = mongoToSqlConverter.convertToSQL(MongoDBQuery, true)

console.log(SQLQuery)
```

```removeUnderscoreBeforeID``` flag, if ```true``` will convert \_id to id, default ```false```

List of supported operators in MongoDB query

* $or
* $and
* $lt
* $lte
* $gt
* $gte
* $ne
* $in

## Running the tests

Run demo with predefined parameters
```
npm run demo
```

Run the test
```
npm run test
```

## License

This project is licensed under the MIT License - see the [LICENSE.md](https://github.com/gordonBusyman/mongo-to-sql-converter/blob/master/LICENSE) file for details

mongo-to-sql-converter

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README