// STRYKE-MSSQL — MICROSOFT SQL SERVER CLIENT FOR STRYKE // QUERY + EXECUTE + PARAMS + TRANSACTIONS + INTROSPECTION

Install

Add the package, then use Mssql. On first use, stryke dlopens the cdylib in-process and registers every mssql__* export via rust_ffi::load_cdylib — only the symbols declared in stryke.toml's [ffi].exports are resolved.

s add github.com/MenkeTechnologies/stryke-mssql

The minimum target is SQL Server 2012 or any Azure SQL instance. The transport is tiberius (pure-Rust TDS) — there is no FreeTDS, ODBC, or system client library to install.

Quick start

use Mssql

var %conn = ( host => "localhost", database => "app",
              username => "sa", password => $ENV{MSSQL_PASS}, trust_cert => 1 )

# parametrized query — @P1, @P2, … bound from params (never interpolated)
val @users = Mssql::query("SELECT id, name FROM users WHERE active = @P1", params => [1], %conn)
p len(@users)

# scalar (first column of first row) + exists (at least one row?)
p Mssql::scalar("SELECT COUNT(*) FROM users", %conn)
p Mssql::exists("SELECT 1 FROM users WHERE id = @P1", params => [42], %conn)

# write — returns rows affected
Mssql::execute("UPDATE users SET name = @P1 WHERE id = @P2", params => ["Ada", 42], %conn)

# transaction batch — commit on success, roll back if any statement fails
Mssql::batch(
    ["INSERT INTO audit (msg) VALUES ('x')", "UPDATE users SET seen = 1 WHERE id = 42"],
    %conn,
)

Connecting

Every Mssql::* call that touches the server takes connection params as a trailing %opts hash. When neither url nor host is given and $MSSQL_URL is set, that ADO connection string is used as a fallback. A tiberius Client is cached per (host, port, database, auth, encrypt); a connection that errors is evicted and reopened on the next call.

API surface

The Mssql package exposes 36 functions across seven groups. Parametrized statements use @P1, @P2, … placeholders bound from params (an arrayref of null / bool / integer / float / string). Identifiers (table/column names) can't be parameterized — use the SQL helpers below for those.

Liveness

Query

val @rows  = Mssql::query("SELECT id, name FROM users WHERE active = @P1", params => [1], %conn)
val $u     = Mssql::query_one("SELECT * FROM users WHERE id = @P1", params => [42], %conn)
val $total = Mssql::scalar("SELECT COUNT(*) FROM users", %conn)
val $has   = Mssql::exists("SELECT 1 FROM users WHERE id = @P1", params => [42], %conn)

Write

Mssql::execute("UPDATE users SET name = @P1 WHERE id = @P2", params => ["Ada", 42], %conn)

Mssql::insert("dbo.users",
    [ { id => 1, name => "Ada" }, { id => 2, name => "Linus" } ],
    %conn)

Mssql::batch(
    ["INSERT INTO audit (msg) VALUES ('x')", "UPDATE users SET seen = 1 WHERE id = 42"],
    %conn)

DDL

Mssql::create_table("dbo.users",
    [ { name => "id",   type => "INT PRIMARY KEY" },
      { name => "name", type => "NVARCHAR(100) NOT NULL" } ],
    %conn)

Introspection

SQL helpers

Pure functions for the cases that can't be parameterized (identifiers, LIKE patterns, IN lists, dynamic SQL). They take no connection and are unit-tested in-crate.

# a column name that can't be a parameter
val $col = Mssql::quote_ident("user name")          # → [user name]

# match a literal substring inside LIKE
val $pat = Mssql::escape_like("100%_off")            # → 100[%][_]off
Mssql::query("SELECT * FROM promo WHERE code LIKE @P1", params => ["%" . $pat . "%"], %conn)

URL helpers

Typed rows

SQL Server result sets are dynamically typed at the wire level. Rather than match every TDS column type, each cell is converted to JSON by trying the candidate Rust types in order — bool, integer, float, string, decimal, uuid, datetime, date, time, binary — and taking the first the driver accepts. Decimals serialize as strings to keep full precision, binary is base64, and datetimes are ISO-8601. Arbitrary queries round-trip without the caller declaring a schema.

Build & test

The Makefile wraps the cargo + stryke commands:

cargo test runs the in-crate unit tests (ADO parse/redact, connection-key defaults, the pure SQL helpers) with no database. Point $MSSQL_HOST (plus $MSSQL_USER / $MSSQL_PASS) at a throwaway SQL Server container to exercise the query path.

Troubleshooting

Why a package, not a builtin

The TDS + TLS stack (tiberius, tokio, rustls) ships once, on demand, as an opt-in package — stryke core is never linked against it. On first use Mssql, stryke dlopens the cdylib in-process and registers every mssql__* export. The cdylib owns one tokio runtime and presents a blocking facade, so from stryke's perspective every Mssql::* function is an ordinary blocking call.

Sibling packages

Part of the stryke package family. Browse the others via the MenkeTechnologiesMeta umbrella repo:

• stryke-arrow — Apache Arrow / Parquet / Feather
• stryke-aws — S3, DynamoDB, SQS, Lambda, STS
• stryke-azure — Blob, Queues, Cosmos DB, Key Vault, Entra
• stryke-clickhouse — ClickHouse
• stryke-demo — live demos for every connector
• stryke-docker — Docker daemon API
• stryke-duckdb — embedded DuckDB SQL engine
• stryke-email — email + campaign client
• stryke-fleet — parallel expect/PTY automation
• stryke-gcp — Cloud Storage, Pub/Sub, Secret Manager, BigQuery, Firestore
• stryke-grpc — reflection-based gRPC client
• stryke-gui — mouse / keyboard / screen / clipboard automation
• stryke-k8s — Kubernetes
• stryke-kafka — Apache Kafka
• stryke-mcpd — MCP servers without a runtime
• stryke-mongo — MongoDB
• stryke-mysql — MySQL / MariaDB
• stryke-neo4j — Neo4j graph (Bolt)
• stryke-office — Office docs / PDF / images
• stryke-parquet — Parquet file inspector
• stryke-polars — Polars + ndarray + linalg + FFT
• stryke-postgres — PostgreSQL
• stryke-redis — Redis / Valkey
• stryke-scrape — web scraping / crawling
• stryke-scylla — ScyllaDB / Cassandra
• stryke-search — Elasticsearch / OpenSearch
• stryke-selenium — browser automation (WebDriver)
• stryke-spark — Spark Connect (no JVM)
• stryke-utils — pure-stryke utility belt
• stryke-zmq — ZeroMQ messaging