Export Collection

# PostgreSQL Power User

> A curated stack collection by [@builtonrails](https://builtonrails.com/@builtonrails)

Go beyond basic queries - full-text search, vectors, and advanced PostgreSQL features.

## LLM Context

```markdown
You are using PostgreSQL with Rails. Leverage pg_search for full-text search, pgvector for embeddings, and use PostgreSQL-specific features like arrays, JSONB, and CTEs.
```

## Stacks

1. **PostgreSQL** (Database)
   - The database that does it all
2. **pg_search** (Search)
   - Full-text search using PostgreSQL's built-in capabilities
3. **pgvector** (AI/ML)
4. **neighbor** (AI/ML)

## Machine-Readable Data

```json
{
  "name": "PostgreSQL Power User",
  "slug": "postgresql-power-user",
  "description": "Go beyond basic queries - full-text search, vectors, and advanced PostgreSQL features.",
  "llm_prompt": "You are using PostgreSQL with Rails. Leverage pg_search for full-text search, pgvector for embeddings, and use PostgreSQL-specific features like arrays, JSONB, and CTEs.",
  "visibility": "public",
  "author": {
    "username": "builtonrails",
    "name": "BuiltOnRails"
  },
  "forked_from": null,
  "stats": {
    "likes": 0,
    "forks": 0,
    "views": 163
  },
  "stacks": [
    {
      "name": "PostgreSQL",
      "category": "Database",
      "position": 0,
      "note": "The database that does it all"
    },
    {
      "name": "pg_search",
      "category": "Search",
      "position": 1,
      "note": "Full-text search using PostgreSQL's built-in capabilities"
    },
    {
      "name": "pgvector",
      "category": "AI/ML",
      "position": 2,
      "note": null
    },
    {
      "name": "neighbor",
      "category": "AI/ML",
      "position": 3,
      "note": null
    }
  ],
  "created_at": "2026-01-22T02:27:33Z",
  "updated_at": "2026-01-22T02:27:33Z",
  "exported_at": "2026-09-20T19:34:46Z"
}
```

---

_Exported from [BuiltOnRails](https://builtonrails.com) on September 20, 2026_