# buildmsql

> buildmsql build sql for mariadb connector

Latest version **1.7.4** (published 2026-04-18) · MIT license · 0 weekly downloads

## Install

```sh
npm install buildmsql
pnpm add buildmsql
yarn add buildmsql
bun add buildmsql
```

## Health

**Score 55/100 (C)** — status: active.

Positive: has types; esm support; no vulnerabilities.

Warnings: low downloads.

## Facts

| | |
|---|---|
| Version | 1.7.4 |
| Published | 2026-04-18 |
| First published | 2021-06-06 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | bundled |
| Module format | ESM + CommonJS |
| Dependencies | 0 |
| Unpacked size | 2.3 MB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 0 |
| Author | webigorkiev |
| Maintainers | webigorkiev |
| Keywords | maraidb, maraidb sql builder, sql builder |

## Links

- npm: https://www.npmjs.com/package/buildmsql
- Repository: https://github.com/webigorkiev/buildmsql
- npm.io page: https://npm.io/package/buildmsql

## Alternatives

- [@sindresorhus/slugify](https://npm.io/package/@sindresorhus/slugify.md) — 3.7M weekly downloads
- [solid-js](https://npm.io/package/solid-js.md) — 2.7M weekly downloads
- [expo-glass-effect](https://npm.io/package/expo-glass-effect.md) — 2.5M weekly downloads
- [nanoassert](https://npm.io/package/nanoassert.md) — 780.8K weekly downloads
- [@ffmpeg/ffmpeg](https://npm.io/package/@ffmpeg/ffmpeg.md) — 529.5K weekly downloads

## Recent versions

- 1.7.4 (latest) — 2026-04-18
- 1.7.2 — 2026-03-30
- 1.7.1 — 2026-01-25
- 1.7.0 — 2024-10-18
- 1.6.9 — 2023-02-22
- 1.6.8 — 2023-02-22
- 1.6.7 — 2023-02-22
- 1.6.6 — 2023-02-22
- 1.6.5 — 2023-02-22
- 1.6.4 — 2023-02-22
- 1.6.3 — 2023-02-21
- 1.6.2 — 2023-02-21
- 1.6.1 — 2022-08-17
- 1.6.0 — 2022-08-13
- 1.5.2 — 2022-08-08
- … 45 more at https://npm.io/package/buildmsql/versions

## README

<h1 align="center"> buildmsql </h1>
<p align="center">
  <b>buildmsql is a builder sql for mariadb connector</b>
</p>

## Description
buildmsql helps you build sql for mariadb connector

Documentation - https://webigorkiev.github.io/buildmsql/

## Installation

```bash
npm i buildmsql
```

## Usage
### Single connection

```typescript

import {Query, QueryOptions} from "buildmsql";

const db = new Query(opt as {
    // QueryOpinions
    // Debug level: 0 - no debag info, 1 - _buildmsqlQueries text and timing
    debug?: 0|1,

    // Used for manticore search
    nativeTransactions?: boolean,

    // pattern *string* regex pattern to select pools. Example, `"slave*"`. default `'*'`
    pattern?:string,

    // *string* pools selector. Can be 'RR' (round-robin),
    // 'RANDOM' or 'ORDER' (use in sequence = always use first pools unless fails)
    selector?: "RR"|"RANDOM"|"ORDER"
})

const connection = await db.createConnection({
    host: 'mydb.com',
    user:'myUser',
    password: 'myPwd'
    
    // mariadb.ConnectionConfig
});

```

### Pool

```typescript
import {Query, QueryOptions} from "buildmsql";

const db = new Query({
    // QueryOpinions
})

const pool = db.createPool({
    // mariadb.PoolConfig
})

```

---
_Source: https://npm.io/package/buildmsql · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._