cianfhoghlaim/cianchosaint / .agents/skills/lancedb
lancedb
Verified| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 27.4 KB |
| references/advanced-rag-patterns.md | markdown | 4.5 KB |
| references/embed-functions-registry.md | markdown | 3.6 KB |
| references/geospatial-fts.md | markdown | 2.5 KB |
| references/hosting-lancedb-docker-compose.md | markdown | 13.5 KB |
| references/hosting-lancedb-r2.md | markdown | 3.0 KB |
| references/ibis-integration.md | markdown | 2.9 KB |
| references/lance-namespace-and-iceberg.md | markdown | 3.3 KB |
| references/lance-ray-distributed.md | markdown | 2.8 KB |
| references/lance-vs-iceberg.md | markdown | 3.7 KB |
| references/lancedb-cloud.md | markdown | 2.5 KB |
| references/lancedb-reference-index.md | markdown | 3.0 KB |
| references/multimodal-fat-tables.md | markdown | 3.9 KB |
| references/time-travel-rag.md | markdown | 2.9 KB |
| references/typescript-modern-api.md | markdown | 3.7 KB |
references/lancedb-cloud.md
View on GitHub# LanceDB Cloud
LanceDB Cloud is the managed, serverless LanceDB offering. It runs
in 4 regions and includes auto-compaction + auto-reindexing.
## Regions
- `us-east-1` (Virginia)
- `us-west-2` (Oregon)
- `eu-west-1` (Ireland) — **the Cianfhoghlaim region**, closest to Galway
- `ap-south-1` (Mumbai)
## Connection
```python
import lancedb
import os
db = lancedb.connect(
"db://my-database",
api_key=os.environ["LANCEDB_API_KEY"],
region="eu-west-1",
)
```
Or via env vars:
```bash
# .env
LANCEDB_URI=db://my-database
LANCEDB_API_KEY=...
LANCEDB_REGION=eu-west-1
```
```python
db = lancedb.connect(
os.environ["LANCEDB_URI"],
api_key=os.environ["LANCEDB_API_KEY"],
region=os.environ["LANCEDB_REGION"],
)
```
## Features
| Feature | Description |
|:--|:--|
| **Auto-compaction** | Runs every 5 minutes; no manual `compact()` needed |
| **Auto-reindexing** | Re-creates HNSW index on every 1k writes |
| **Multi-region** | Pick the region closest to your data |
| **Serverless** | No instance management; pay per query + storage |
| **Backups** | Daily snapshots, point-in-time recovery |
| **Encryption at rest** | AES-256 |
| **Private endpoints** | Available on Enterprise plan |
## Pricing model
- **Storage**: per GB per month (varies by region)
- **Queries**: per 1k vector queries
- **Writes**: per 1k rows inserted
- **Free tier**: 100 GB storage, 10M queries/month
For Cianfhoghlaim production, use LanceDB Cloud in `eu-west-1` for the
leabharlann + curriculum indexes.
## Local → Cloud migration
```python
# 1. Local LanceDB
local_db = lancedb.connect("./lancedb_data")
table = local_db.open_table("my_table")
print(f"{table.count_rows()} rows")
# 2. Cloud LanceDB
cloud_db = lancedb.connect("db://my-database", api_key=..., region="eu-west-1")
cloud_table = cloud_db.create_table("my_table", schema=table.schema, mode="overwrite")
# 3. Bulk copy
batch = []
for batch_start in range(0, table.count_rows(), 1000):
df = table.to_pandas().iloc[batch_start:batch_start+1000]
batch.append(df)
cloud_table.add(batch)
```
## Cloudflare R2 + LanceDB Cloud
For a self-hosted R2 backend (the Cianfhoghlaim production target), use the
rclone-sidecar Compose pattern (see
`references/hosting-lancedb-docker-compose.md` for the docker-compose
example). The pattern:
1. Run an rclone container mounted as a FUSE filesystem at `/data/lance`
2. Run the LanceDB-using service with `/data/lance` mounted
3. rclone syncs the local `/data/lance` to R2 every N minutes
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |