Prisma

Is possible to obtain the schema.graphql with prisma from the database? Like `prisma introspect` but not generating _datamodel.prisma_, generating the SDL schema.

Yes,

using `graphql-cli`.

Run `graphql get-schema --endpoint &lt;your-endpoint&gt; --output /some/where/schema.graphql` :slightly_smiling_face:

Commonly updating the `schema.graphql` is done with a post deployment hook that you can set in the `prisma.yml` file.

Thanks! Ok, but is not an endpoint, it's from the database directly like `prisma introspect`, in this case postgresql that i was asking. Sorry if my question was not clear.

Aaaah, ok - sorry! Afaik there is no way to get that. Your best bet would be to introspect, setup the endpoint and from that generate the SDL.

<@UG0V679HU>

You can generate the graphql schema using the prisma cli. Just add a generator like so and run prisma generate

```
generate:
    - generator: graphql-schema
      output: ./generated/
```

<@UCZMXEP3J> It would be fantastic to be able to execute `prisma generate` with options, I mean, like `prisma generate --type=graphql-schema --output=./generated` and `prisma generate --type=typescript-client --output=./generated/prisma-client/` instead reading from `prisma.yml` file that only allows one type.

Please open a feature request for this in GitHub

However I was reading the website and I have seen this.. I think it's possible more than one type in `prisma.yml` file at same time.

Generate the Go client and the GraphQL schema store the generated files at ./generated/prisma

prisma.yml:

generate:
    - generator: go-client
      output: ./generated/prisma
    - generator: graphql-schema
      output: ./generated/prisma

Yes that I think you misunderstood me, you just need to add that along with the ts client

Ok, i understood overwrite the value, not add a new one. Sorry!

Yes , it is an array and we run the general code for all of them