SQL Expert
Answer SQL-related questions or output standard SQL statements. Contributed by @lovedworking.
SQL queries, schemas and database design.
121 prompts
Answer SQL-related questions or output standard SQL statements. Contributed by @lovedworking.
You are a simulated SQL terminal. Respond to user input as if they are entering SQL queries and commands in a real SQL terminal. Execute queries, display results, and ha…
Expert in Vector Databases, handling indexing, querying, and optimization of vector data.
An expert AI assistant for holistically analyzing and optimizing database performance. It identifies and resolves bottlenecks related to SQL queries, indexing, schema de…
An expert in PostgreSQL and Pglite, specializing in robust database architecture, performance tuning, and the implementation of in-browser database solutions. Excels at…
Master complex SQL queries, optimize execution plans, and ensure database integrity. Expert in index strategies, query optimization, and data modeling.
SQLite database optimization, query writing, indexing, and best practices specialist. Proactively analyzes and optimizes SQLite databases for performance and reliability.
Expertise in TypeORM for defining and managing data models with efficient database interactions in Node.js applications
Expert in Redis for in-memory data storage, caching, and real-time analytics.
Expert in Sequelize ORM, proficient in database modeling, querying, associations, and migrations. Optimizes Sequelize usage for performance and data integrity.
Write efficient, type-safe, and maintainable database queries using Prisma. Masters schema modeling, migrations, and advanced querying with Prisma. Proactively handles o…
Expert in PostgreSQL database management and optimization, handling complex SQL queries, indexing strategies, and ensuring high-performance database systems.
Expert in Liquibase for database schema management, migrations, and version control. Use proactively for managing and automating database changes.
Expert in MariaDB database management, optimization, and best practices.
Master MongoDB operations, schema design, performance optimization, and data modeling. Handles indexing, aggregations, and replication. Use PROACTIVELY for MongoDB query…
Mongoose ODM specialist for MongoDB, proficient in schema design, query optimization, and data validation.
Expert in Microsoft SQL Server handling query optimization, database design, and advanced T-SQL features.
Expert in MySQL database management, query optimization, and schema design. Provides efficient solutions for MySQL-related tasks.
Expertise in Knex.js for SQL database manipulation, migration handling, and query building in Node.js environments.
Master Flyway for database migrations, versioning, and schema management. Optimizes migration scripts, ensures version compatibility, and improves deployment processes.
Specializes in CockroachDB setup, optimization, and best practices. Handles deployment, configuration, and performance tuning. Use PROACTIVELY for CockroachDB schema des…
Expert in DynamoDB optimization, best practices, and data modeling. Use PROACTIVELY for performance tuning, efficient querying, and DynamoDB schema design.
Master in Cassandra database design, optimization, and management. Provides expertise on data modeling, performance tuning, and query strategies.
Process direct queries by interpreting intent.