---
title: Create Your First Index
description: Create a ParadeDB index over your table
canonical: https://www.paradedb.com/docs/start/create-your-first-index
---
Create a ParadeDB index over the `mock_items` table from [Configure Your
Environment](/start/configure-your-environment). The same index supports text
search, vector search, filtering, sorting, and aggregations in the next page.
```sql SQL
CREATE INDEX search_idx ON mock_items
USING paradedb (
id,
description,
embedding vector_cosine_ops,
category,
rating,
in_stock,
created_at,
last_updated_date,
latest_available_time,
metadata,
weight_range
);
```
```ts Drizzle
import { sql } from "drizzle-orm";
await db.execute(sql`
CREATE INDEX search_idx ON mock_items
USING paradedb (
id,
description,
embedding vector_cosine_ops,
category,
rating,
in_stock,
created_at,
last_updated_date,
latest_available_time,
metadata,
weight_range
)
`);
```
```python Django
from django.db import connection
with connection.cursor() as cursor:
cursor.execute("""
CREATE INDEX search_idx ON mock_items
USING paradedb (
id,
description,
embedding vector_cosine_ops,
category,
rating,
in_stock,
created_at,
last_updated_date,
latest_available_time,
metadata,
weight_range
)
""")
```
```python SQLAlchemy
from sqlalchemy import text
with engine.begin() as conn:
conn.execute(text("""
CREATE INDEX search_idx ON mock_items
USING paradedb (
id,
description,
embedding vector_cosine_ops,
category,
rating,
in_stock,
created_at,
last_updated_date,
latest_available_time,
metadata,
weight_range
)
"""))
```
```ruby Rails
ActiveRecord::Base.connection.execute <<~SQL
CREATE INDEX search_idx ON mock_items
USING paradedb (
id,
description,
embedding vector_cosine_ops,
category,
rating,
in_stock,
created_at,
last_updated_date,
latest_available_time,
metadata,
weight_range
);
SQL
```
```cs EF Core
await dbContext.Database.ExecuteSqlRawAsync("""
CREATE INDEX search_idx ON mock_items
USING paradedb (
id,
description,
embedding vector_cosine_ops,
category,
rating,
in_stock,
created_at,
last_updated_date,
latest_available_time,
metadata,
weight_range
);
""");
```
If `search_idx` already exists, drop it first with `DROP INDEX search_idx;`.
Every indexed column is a field you can search, filter, sort, group, or
aggregate. The `key_field` index option is deprecated and ignored.
The `description` column is indexed for full-text search, `embedding`
is indexed for vector search, and fields like `rating`, `category`, and
`created_at` are available for filters, Top K queries, and facets.
For production schemas, define this index in your migration system instead of
running ad hoc SQL. The full [Create an
Index](/reference/indexing/create-index) reference includes framework-native
examples and tokenizer options.
Next, [run your first queries](/start/run-queries).