npm package: @pridevr/cirql
Description: SurrealDB ORM & Query Builder
Latest version: 1.0.5

<br>

<div align="center">
    <img src="https://raw.githubusercontent.com/StarlaneStudios/cirql/main/.github/branding/logo.png">
</div>

<div align="center">
    <h3>⚠️ This project is no-longer being maintained and should not be used in production! ⚠️</h3>
</div>

<hr />

<br>

<p align="center">
<a href="https://cirql.starlane.studio">
    <img src="https://img.shields.io/badge/docs-available-de12b4">
  </a>
  <a href="https://github.com/StarlaneStudios/cirql/blob/master/LICENSE">
    <img src="https://img.shields.io/github/license/StarlaneStudios/cirql"> 
  </a>
  <a href="https://discord.gg/exaQDX2">
      <img src="https://img.shields.io/discord/414532188722298881">
  </a>
  <img src="https://img.shields.io/bundlephobia/min/cirql">
  <img src="https://img.shields.io/github/contributors/StarlaneStudios/cirql">
</p>

Cirql (pronounced Circle) is a simple lightweight ORM and query builder for [SurrealDB](https://surrealdb.com/), providing fully type-safe queries and [Zod](https://github.com/colinhacks/zod) powered parsing & validation. Unlike most query builders, Cirql's flexible nature leaves you with complete control over your queries, while still providing powerful APIs to query your database in a concise manner.

## Features
- 🔗 Connect to SurrealDB over stateful WebSockets or stateless HTTP requests
- 📦 Support for query batching & transactions
- ⚙️ Zod-powered schema validation of query results
- 📝 Full TypeScript support with Zod schema inference
- 💎 Write flexible queries using the Query Writer API
- ✂️ Support for raw query strings and native Surreal functions
- 🔥 Works both in browser and backend environments

## Notice
Cirql is still in early developmental stages. While you can use it for production applications, it may still lack specific features and edge cases. Feel free to submit feature requests or pull requests to add additional functionality to Cirql. We do ask you to please read our [Contributor Guide](CONTRIBUTING.md).

While we try to prevent making any significant API changes, we cannot guarantee this.

## Installation
The first step to use Cirql is to install the package from npm, together with a supported version of zod.
```
npm install cirql zod
```

## How to use
You can [read our documentation](https://cirql.starlane.studio/) for information on how to use Cirql.

## Example
The following query fetches up to 5 organisations that are enabled and have the given user as a member. The result is parsed and validated using the provided Zod schema.

```ts
import { RecordSchema, select } from 'cirql';
import { z } from 'zod';

// Define your Zod schemas
const Organisation = RecordSchema.extend({
    name: z.string(),
    isEnabled: z.boolean(),
    createdAt: z.string()
});

// Execute a select query
const organisations = await cirql.execute({
    query: select()
        .from('organisation')
        .with(Organisation) // Specify the schema
        .limit(5)
        .where({
            isEnabled: true,
            members: any(userId)
        })
});
```

Visit our [Basic Usage](https://cirql.starlane.studio/docs/guide/basic-usage) guide for more examples.

## Contributing
We welcome any issues and PRs submitted to Cirql. Since we currently work on multiple other projects and our time is limited, we value any community help in supporting a rich future for Cirql.

Before you open an issue or PR please read our [Contributor Guide](CONTRIBUTING.md).

### Requirements
- [PNPM](https://pnpm.io/) (npm i -g pnpm)

### Roadmap
You can find the roadmap of intended features [here](ROADMAP.md).

### Changelog
The changelog of previous versions can be found [here](CHANGELOG.md).

### Live Development
To run in live development mode, run `pnpm dev` in the project directory. This will start the Vite development server.

## Maintainers
<a href="https://starlane.studio">
  <img src="https://raw.githubusercontent.com/StarlaneStudios/cirql/main/.github/branding/starlane.png" height="64">
</a>

Cirql is built and maintained by <a href="https://starlane.studio/">Starlane Studios</a> at no cost. If you would like to support our work feel free to [donate to us](https://paypal.me/StarlaneStudios) ⚡

## License

Cirql is licensed under [MIT](LICENSE)

Copyright (c) 2023-2025, Starlane Studios