Results for “mssql”

You are an expert in Knex.js, the flexible SQL query builder for Node.js that supports PostgreSQL, MySQL, SQLite, and MSSQL. You help developers write type-safe queries with a chainable API, manage database migrations and seeds, build complex joins and subqueries, and use transactions — providing direct SQL control without the overhead of a full ORM.

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

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning 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

SQL patterns for database querying and design

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.

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

Generate XML configuration files and execute SSMA Console commands for Oracle to SQL Server database migration, including schema conversion and data migration.

Creates and manages Cloud SQL instances, databases, and users for MySQL, PostgreSQL, and SQL Server using gcloud CLI commands.

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

Optimize PostgreSQL databases with advanced features, performance tuning, and best practices for JSONB, full-text search, window functions, and indexing.

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.

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.

Drizzle Raw SQL

Translate natural language into SQL queries, optimize database performance, generate migrations, explore schemas, and work with ORMs across PostgreSQL, MySQL, SQLite, and SQL Server.

Provides MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.

Analiza datos en bases de datos relacionales con consultas SQL eficientes y legibles, incluyendo joins, window functions, CTEs y subqueries, para extraer insights directamente de la base de datos.

Streams change data capture from Microsoft SQL Server into Redpanda or Kafka using Redpanda Connect's microsoft_sql_server_cdc input, covering setup, configuration, and troubleshooting.

Migrates data from MongoDB, PostgreSQL, MySQL, Neo4j, Kafka, and JSONL into SurrealDB with full and incremental CDC synchronization.

Use when querying a Rulebase workspace with SQL through the MCP server's query tool — writing queries that finish inside the statement timeout, and avoiding the join fan-outs that silently inflate QA evaluation counts. Trigger for "query my Rulebase data", "the query timed out", "statement timeout", "canceling statement due to statement timeout", counts that don't reconcile between two Rulebase queries, criterion counts exceeding team counts, or any multi-step analysis over Rulebase conversations and evaluations.

Executa consultas, inspeção de schema e mutações seguras (DML/DDL com dry-run) no PostgreSQL via servidor MCP, exigindo confirmação explícita para alterações.

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.

Teaches standard SQL for creating, managing, and querying relational databases, covering DDL, DML, DQL, DCL, joins, subqueries, and best practices.

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

Provides safe, reversible database schema change patterns for PostgreSQL, MySQL, and common ORMs, with guidance on zero-downtime deployments, rollbacks, and migration tooling.

Quick reference for PostgreSQL best practices covering query optimization, schema design, indexing, Row Level Security, and connection pooling.

Execute SQL on a Databricks SQL Warehouse

Administra bases de datos PostgreSQL, MySQL, Redis y SQLite: diseña esquemas, optimiza queries, configura migraciones, replicación y backups.

Connect to PostgreSQL, MySQL, SQLite, and SQL Server databases using SQLAlchemy, Pandas, and DuckDB. Read and write tables, manage sessions, and handle connection strings securely.

Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls, including index tuning recommendations, query plan analysis, health monitoring, and schema intelligence.

Kysely type-safe SQL query builder - End-to-end type safety from schema to queries, migrations, transactions, plugins

Explains syntax differences for common SQL operations across PostgreSQL, MySQL, SQL Server, and Oracle, including auto-increment keys, string concatenation, date functions, pagination, booleans, JSON, case sensitivity, and recursive CTEs.

Run SQL queries and psql meta-commands against PostgreSQL databases via the psql CLI, with options for file execution, tuples-only output, and timeouts.

Provides MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.