> ## Documentation Index
> Fetch the complete documentation index at: https://tygress.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Tygress

Typescript ORM for Postgres, runs on Node.js

If it is your first time here consider [getting started with Tygress.](/guides/getting-started)

# Main goals 🎯

* Support all Postgres features to get the most out of your database
  * Including changing Postgres config, per-table overrides, explicit locking, DDL etc...
* Have minimum performance overhead and maximum control
  * You should have full control over which columns and how many rows you `SELECT`, `INSERT` etc...
  * It should be clear what queries are ran when and where
* Have full type safety
  * This includes query results, building queries and other interactions with Postgres
  * Keep simple queries simple but offer solid support for building complex ones

<Columns cols={2}>
  <Card title="Continue reading" icon="arrow-right" href="/quickstart">
    Quickstart
  </Card>

  <Card title="Defining tables" icon="table" href="/guides/defining-tables">
    Define your <Tooltip tip="Tygress representation of objects in your database">schema</Tooltip> using <Tooltip tip="Classes and decorators that define your schema">entities</Tooltip>
  </Card>

  <Card title="Query builder" icon="wrench" href="/guides/query-builder">
    Write complex queries with the <Tooltip tip="DB.queryBuilder('u', Users)">QueryBuilder</Tooltip>
  </Card>

  <Card title="Postgres config" icon="wrench" href="/guides/postgres-config">
    Change <Tooltip tip="Config parameters in Postgres, such as work_mem">Postgres config</Tooltip> on the fly
  </Card>

  <Card title="Migrations CLI" icon="triangle-exclamation" href="/guides/migrations">
    Manage your database using Tygress CLI
  </Card>

  <Card title="Examples repository" icon="magnifying-glass" href="https://github.com/pert5432/tygress-examples">
    Explore Tygress by example
  </Card>
</Columns>