Results for “esql”

Write and run analytical SQL queries against Redpanda SQL (Oxla), a distributed PostgreSQL-wire-compatible columnar database, including data loading, external sources, and type handling.

Expert-level PostgreSQL database administration, advanced queries, performance tuning, and production operations

SQL patterns for database querying and design

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

Translates natural language data intents into syntactically valid Perfetto SQL queries and executes them against a local trace file using trace_processor.

Compare identical tables across two SQL Server instances using Python with mssql-python and Apache Arrow, detecting missing rows, column mismatches, schema drift, and generating a reconciliation report.

Provides PostgreSQL query patterns covering SELECT, JOINs, subqueries, CTEs, window functions, and advanced SQL techniques.

Microsoft SQL Server T-SQL procedural language. Covers stored procedures, functions, triggers, error handling, and SQL Server-specific features. Use for SQL Server database server-side programming. USE WHEN: user mentions "tsql", "T-SQL", "SQL Server procedures", "SQL Server functions", "TRY...CATCH", "THROW", "sp_executesql", "SSMS" DO NOT USE FOR: basic SQL Server SQL - use `sqlserver` instead, PostgreSQL - use `plpgsql` instead, Oracle - use `plsql` instead

Drizzle Raw SQL

AWS infrastructure management — EKS, ECR, VPC, RDS, ElastiCache, S3, Route53, ACM, Secrets Manager, CloudWatch, IAM

Deploys and configures osquery for real-time endpoint monitoring using SQL-based queries to inspect running processes, open ports, installed software, and system configuration.

Generate optimized SQL queries from natural language descriptions across multiple database platforms including BigQuery, PostgreSQL, MySQL, and Snowflake. Reads database schemas from uploaded files or diagrams to produce accurate, production-ready queries.

Generate, predict, and embed protein sequences and structures using ESM3, ESMC, and ESMFold2 with local or cloud inference.

Designs Elasticsearch indexes and mappings, tunes queries, sizes clusters, and handles operations like shard/replica strategy, ILM, monitoring, troubleshooting, and safe reindexing or upgrades.

Optimizes SQL queries by analyzing execution plans, rewriting patterns, and applying performance techniques for PostgreSQL and MySQL.

Ecto database toolkit reference for Elixir. Covers schemas, changesets with validation, composable query DSL, joins, preloading, aggregates, migrations, transactions with Ecto.Multi, and embedded schemas.

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues using execution plan analysis, indexing strategies, and set-based operations.

SQL with dbt. SQL queries.

Write and debug SOQL queries covering SELECT syntax, filters, sorting, pagination, relationship traversal, and aggregate functions.

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

Guides setting up Drizzle ORM with Vercel Postgres and Vercel KV for a manufacturing analysis app, covering schema definition, queries, migrations, caching, sessions, and rate limiting.

Manage customers, sales orders, invoices, inventory, and records in Oracle NetSuite ERP using SuiteQL queries and composio toolkits.

Optimizes SQL queries with execution plan analysis, index suggestions, and query rewriting

Foundational SQL patterns for query writing, schema design, and dialect differences. Use when writing SQL queries, designing database schemas, understanding SQL syntax across PostgreSQL/MySQL/SQLite, or preparing SQL for conversion to other query languages. This is a meta-skill for SQL derivatives.

Foundational SPARQL patterns covering RDF querying, triple patterns, graph patterns, and semantic web fundamentals. Use when querying RDF data or working with knowledge graphs. This is the entry point for SPARQL development.

Diagnose and observe an Oxla distributed analytical database using system catalog tables, Prometheus metrics, runtime log-level changes, and troubleshooting workflows for slow queries, node health, and memory/OOM pressure. Also covers debugging Oxla's external data sources, including the Redpanda/Kafka ingestion path.

Use when implementing elk functionality with production-grade patterns and safeguards.

Write SOQL queries that group or filter records by date periods using the 13 SOQL date functions, with rules for WHERE vs GROUP BY placement, date-literal comparisons, and fiscal-year restrictions.

SQL injection occurs when untrusted user input is interpolated directly into database queries, allowing attackers to alter query logic. Detect via single-quote errors, boolean-based blind responses (AND 1=1 vs AND 1=2), time-delay payloads (SLEEP, WAITFOR), UNION column enumeration, and error messages from MySQL, Oracle, MSSQL, PostgreSQL. Tools: sqlmap, sqlbftools, Burp Suite, wfuzz with SQLi fuzz strings.

Oracle Database specific features. Covers data types, sequences, synonyms, partitioning, and Oracle-specific SQL syntax. Use for Oracle database work. USE WHEN: user mentions "oracle", "oracle database", "sequences", "synonyms", "DUAL", "SYSDATE", "NVL", "DECODE", "Oracle partitioning", "Oracle specifics" DO NOT USE FOR: PostgreSQL - use `postgresql` instead, SQL Server - use `sqlserver` instead, PL/SQL programming - use `plsql` instead

Execute SQL on a Databricks SQL Warehouse

MySQL relational database. Covers queries, indexes, and optimization. Use when working with MySQL databases. USE WHEN: user mentions "mysql", "mariadb", asks about "AUTO_INCREMENT", "ON DUPLICATE KEY UPDATE", "GROUP_CONCAT", "mysql specific syntax" DO NOT USE FOR: PostgreSQL - use `postgresql` instead, MongoDB - use `mongodb` instead, Oracle - use `oracle` instead, SQL Server - use `sqlserver` instead

Comprehensive guide for developing on EspoCRM - metadata-driven CRM with service layer architecture

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features