Edit data rows, table structure, or query. Database security at its best: SSH tunneling, TLS encrypt end-to-end. Multiple drivers: MySQL, PostgreSQL, SQL Server, Cassandra, Cockroach, Redis. In Data Virtuality, NoSQL databases such as MongoDB can be queried with standard SQL statements. The closest I have so far is finding and counting records that contain the same phone number: dbh.person_document. Auto-complete queries in the mongo shell, use a drag-and-drop interface to build queries, query MongoDB with SQL, or break down aggregation queries in. Description: With a simple design and powerful features, TablePlus makes database management easier, faster & more efficient on your iOS devices. I'm using MongoDB 2.4.2 on Debian with pyMongo and MongoEngine. I have a mongo-backed contact database going and I'm trying to find duplicate entries in a bunch of different ways.įor example, if 2 contacts have the same phone number they are flagged as a possible duplicate, ditto for email, etc.