> For the complete documentation index, see [llms.txt](https://codemash.gitbook.io/codemash/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://codemash.gitbook.io/codemash/sdks/database/collections/count-records.md).

# Count Records

Count Records.

**Collections** hold your records. Norbix generates a full CRUD + query API over each collection from its schema, with record-level ownership and triggers. Counts the records.

This method is on the **Hub** surface (`norbix.hub.database`) — call it from admin tooling or IaC.

{% hint style="info" %}
These examples assume the SDK is installed and your credentials are set as environment variables — each client reads them automatically, so the constructors below take no arguments. See [Install a Norbix SDK](/codemash/sdks/install.md).
{% endhint %}

{% tabs %}
{% tab title="JavaScript / TypeScript" %}

```ts
import { Norbix } from '@norbix.ai/ts';
const norbix = new Norbix();

const result = await norbix.hub.database.countRecords({
  collectionName: 'orders',
  databaseIntegrationId: 'int_4kX9mQvR2tYw7ZbC1dFgHj',
  filter: '{"status":"active"}',
  schemaVersion: 10,
});
```

{% endtab %}

{% tab title=".NET" %}

```csharp
using Norbix.Sdk;
using Norbix.Sdk.Types.Hub;

using var client = new NorbixClient();

var result = await client.Database.CountRecordsAsync(new CountRecords
{
    CollectionName = "orders",
    DatabaseIntegrationId = "int_4kX9mQvR2tYw7ZbC1dFgHj",
    Filter = "{\"status\":\"active\"}",
    SchemaVersion = 10,
});
```

{% endtab %}

{% tab title="Python" %}

```python
from norbix_python import NorbixHub

norbix = NorbixHub()

result = norbix.database.count_records(
    collectionName="orders",
    databaseIntegrationId="int_4kX9mQvR2tYw7ZbC1dFgHj",
    filter="{\"status\":\"active\"}",
    schemaVersion=10,
)
```

{% endtab %}

{% tab title="Go" %}

```go
c, _ := norbix.New(norbix.Options{})
ctx := context.Background()

var result map[string]any
err := c.Hub.Database.CountRecords(ctx, "orders", map[string]any{
	"databaseIntegrationId": "int_4kX9mQvR2tYw7ZbC1dFgHj",
	"filter": "{\"status\":\"active\"}",
	"schemaVersion": 10,
}, &result)
```

{% endtab %}

{% tab title="Dart / Flutter" %}

```dart
import 'package:norbix/norbix_hub.dart';

final hub = NorbixHub();

final result = await hub.database.countRecords(collectionName: 'orders', body: {
  'databaseIntegrationId': 'int_4kX9mQvR2tYw7ZbC1dFgHj',
  'filter': '{"status":"active"}',
  'schemaVersion': 10,
});
```

{% endtab %}

{% tab title="Swift" %}

```swift
import NorbixHub

let client = try NorbixHubClient()

let result = try await client.database.countRecords([
    "collectionName": "orders",
    "databaseIntegrationId": "int_4kX9mQvR2tYw7ZbC1dFgHj",
    "filter": "{\"status\":\"active\"}",
    "schemaVersion": 10,
])
```

{% endtab %}

{% tab title="Kotlin" %}

```kotlin
import ai.norbix.sdk.hub.NorbixHub

val hub = NorbixHub()

val result = hub.database.countRecords(mapOf(
    "collectionName" to "orders",
    "databaseIntegrationId" to "int_4kX9mQvR2tYw7ZbC1dFgHj",
    "filter" to "{\"status\":\"active\"}",
    "schemaVersion" to 10,
))
```

{% endtab %}

{% tab title="CLI" %}

```sh
norbix hub db records count --collectionName orders --databaseIntegrationId int_4kX9mQvR2tYw7ZbC1dFgHj --filter '{"status":"active"}' --schemaVersion 10
```

{% endtab %}
{% endtabs %}

## In Cloud

Manage this visually in Cloud — see [Database → Collections](/codemash/cloud/database/collections.md).

## API reference

Full request and response for this endpoint: [Count Records](/codemash/api-reference/database/collections/count-records.md).