Query Language Snippets

Reset
All Snippets
Python Combined
MongoDB basic CRUD operations.
from pymongo import MongoClient
client = MongoClient("mongodb://localhost:27017/")
db = client.example
db.users.insert_one({"name": "Alice", "age": 30})
docs = db.users.find({"age": {"$gt": 25}})
for doc in docs:
    print(doc)
client.close()
Python Combined
Redis basic operations.
import redis
r = redis.Redis(host='localhost', port=6379)
r.set('foo', 'bar')
print(r.get('foo'))
r.delete('foo')
Cypher Create
Create a relationship between nodes.
MATCH (a:Person), (b:Person)
WHERE a.name = 'Alice' AND b.name = 'Bob'
CREATE (a)-[r:FRIENDS_WITH]->(b)
RETURN r;
Cypher Create
Create a node with properties.
CREATE (n:Person {name: 'Alice', age: 32});
SQL Create
Create an index on a column for faster queries.
CREATE INDEX idx_name ON users(name);
SQL Create
Create a new table with columns and constraints.
CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(255) UNIQUE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
SQL Create
Insert multiple rows into a table.
INSERT INTO products (name, price) VALUES ('Banana', 0.99), ('Cherry', 2.99);
SQL Create
Insert a single row into a table.
INSERT INTO products (name, price) VALUES ('Apple', 1.99);
MongoDB Create
Create an index for faster queries.
db.users.createIndex({ email: 1 }, { unique: true });
MongoDB Create
Insert a single document.
db.users.insertOne({ name: "Alice", age: 28 });
GraphQL Create
Mutation with variables for dynamic input.
mutation CreateUser($name: String!, $email: String!) {
  createUser(name: $name, email: $email) {
    id
    name
  }
}
MongoDB Create
Insert multiple documents.
db.users.insertMany([
  { name: "Bob", age: 35 },
  { name: "Carol", age: 22 }
]);