# PostgreSQL Integration: Dashboards and AI Analytics | Silicon

URL: https://meetsilicon.com/integrations/postgres/

> Connect Silicon to PostgreSQL and query it live through your semantic layer. Point Silicon at a Postgres database or read replica.

Integrations / PostgreSQL
# Silicon + PostgreSQL
Connect Silicon to PostgreSQL and query it live through your semantic layer. Point Silicon at a Postgres database or read replica.
Available on: All plans
Book a demo
30-minute demo with the founder
Features
## What you can do
- Dashboards, scheduled reports and alerts on PostgreSQL data
- AI analyst answers that run as governed SQL against PostgreSQL
- Schema checks that compare pull requests with your live warehouse
- Row- and column-level permissions applied to every query
Set-up
## Connect PostgreSQL
- Create a user or service account in PostgreSQL with read access to the schemas your dbt models build into.
- Add the PostgreSQL connection details in your Silicon project settings.
- Connect your dbt project, or define metrics in Silicon YAML, so Silicon knows your models and metrics.
- Build dashboards, ask the AI analyst or schedule reports. Queries run live in PostgreSQL.
Detailed instructions for connecting PostgreSQL are in the Silicon docs. Questions about your setup? Talk to Sujay.
FAQ
## PostgreSQL questions
### Does Silicon copy my data out of PostgreSQL? +
Silicon queries PostgreSQL live through your semantic layer, so the data stays in your PostgreSQL account.
### What access does Silicon need in PostgreSQL? +
Read access to the schemas and tables your dashboards and metrics use. Silicon does not need write access to your data.
### Do we need dbt? +
It helps, because Silicon reads your models and descriptions from it. Metrics can also be defined in Silicon YAML without a dbt project.
### Which Silicon plans include PostgreSQL? +
All plans. See the pricing page for what each plan includes.
## More warehouses integrations
- Snowflake ->
- BigQuery ->
- Databricks ->
- Amazon Redshift ->
- All integrations ->
## Tell us where your data lives today.
Book 30 minutes with the founder. Tell us where your data is today, and see Silicon running on sample data.
Book a demo
30-minute demo with the founder