# ezhst db query

Run a SQL statement or file.

## Usage

```
ezhst db query "<sql>" | --file <file.sql>
```

Statements run through the CLI time out after 15 seconds.

## In scripts and agents

Add `--json` to read the result from stdout. Progress goes to stderr. On failure the process exits with code 1 and prints `{"error": "..."}`. Without a TTY the CLI never prompts, so pass every value as a flag.

```
npx ezhst db query "<sql>" | --file --json
```

## Related commands

- [`ezhst db info`](/docs/cli/db-info): Show the connection string, shadow connection string and tables.
- [`ezhst db create`](/docs/cli/db-create): Create the project's Postgres database.
- [`ezhst db rows`](/docs/cli/db-rows): Browse rows in a table.
- [`ezhst db reset-password`](/docs/cli/db-reset-password): Rotate the password and print the new connection string.
- [`ezhst db delete`](/docs/cli/db-delete): Delete the database.