Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Create a custom GPT to chat with your PostgreSQL Database in ChatGPT. The most popular DB you can get from Supabase, Vercel, AWS or Azure. Ask Q&A in ChatGPT and refer to database by project name.

NotificationsYou must be signed in to change notification settings

cameronking4/chat-with-postgresql-chatgpt-action

Repository files navigation

Use natural language to retrieve database values realtime and have ChatGPT analyze data from storage options from Supabase or Vercel - KV or Postgres DB. Host your own Next14 Admin API to securely browse your DB through ChatGPT

This is aNext.js project bootstrapped withcreate-next-app for storing database connection strings for various side projects.

This API using Next14 enables me to have a custom GPT in ChatGPT where I can query data from various side project. I can now ask ChatGPT how many users do I have and other SQL queries using natural language.

Screenshot 2024-09-18 at 10 41 29 PM

You could extend this API to build a frontend application to manage your side projects.

Get connection string for my project BuyMyRepo, then use it to understand my database. Once understood, show me a table of my users with their app profile details in a nice table.

Deploy on Vercel

Deploy this project in one click:

Deploy with Vercel

Check out ourNext.js deployment documentation for more details.

Create a Custom GPT in ChatGPT

  1. Deploy this project to Vercel with your .env values for a PostgresQL DATABASE_URL and your own API_KEY password
  2. Click Actions
  3. ***Choose API KEY option for Authorization and select the option "Custom" header
  4. Set the custom header value to "api-key"*** & set your API_KEY value here
  5. Copy & Paste the following YAML spec into the "Schema":
openapi:3.1.0info:title:PostgreSQL Database Viewer APIdescription:API for interacting with PostgreSQL databases to retrieve schema, query tables dynamically, and manage project connection strings.version:"1.0.0"servers:  -url:https://postgre-sql-databse-viewer-action.vercel.appcomponents:securitySchemes:ApiKeyAuth:type:apiKeyin:headername:api-keyschemas:Project:type:objectproperties:projectName:type:stringdescription:The name of the project.connectionString:type:stringdescription:The connection string for the PostgreSQL database.ErrorResponse:type:objectproperties:error:type:stringdetails:type:objectsecurity:  -ApiKeyAuth:[]paths:/api/get-db-schema:post:operationId:getDbSchemasummary:Get Database Schemadescription:Retrieve the schema (table names and column details) from the specified PostgreSQL database.security:        -ApiKeyAuth:[]requestBody:required:truecontent:application/json:schema:$ref:'#/components/schemas/Project'responses:'200':description:Schema information retrieved successfully.content:application/json:schema:type:arrayitems:type:objectproperties:table_name:type:stringcolumn_name:type:stringdata_type:type:string'401':description:Unauthorized. API key is missing or invalid.'500':description:Error querying the database schema.content:application/json:schema:$ref:'#/components/schemas/ErrorResponse'/api/query-table:post:operationId:queryTablesummary:Query Tabledescription:Query a specified table in the PostgreSQL database and retrieve records based on optional conditions.security:        -ApiKeyAuth:[]requestBody:required:truecontent:application/json:schema:type:objectproperties:connectionString:type:stringdescription:Connection string for the PostgreSQL database.table:type:stringdescription:The name of the table to query.fields:type:arrayitems:type:stringdescription:Optional array of fields to retrieve.conditions:type:objectdescription:Optional conditions for querying records.responses:'200':description:Records retrieved successfully.content:application/json:schema:type:arrayitems:type:objectadditionalProperties:type:string'401':description:Unauthorized. API key is missing or invalid.'500':description:Error querying the table.content:application/json:schema:$ref:'#/components/schemas/ErrorResponse'/api/projects:post:operationId:createProjectsummary:Create Projectdescription:Add a new project with its corresponding connection string to the system.security:        -ApiKeyAuth:[]requestBody:required:truecontent:application/json:schema:$ref:'#/components/schemas/Project'responses:'201':description:Project added successfully.content:application/json:schema:$ref:'#/components/schemas/Project''401':description:Unauthorized. API key is missing or invalid.'500':description:Error adding project.content:application/json:schema:$ref:'#/components/schemas/ErrorResponse'/api/projects/{projectName}:get:operationId:getProjectConnectionStringsummary:Get Project Connection Stringdescription:Retrieve the connection string for a project by its name.security:        -ApiKeyAuth:[]parameters:        -name:projectNamein:pathrequired:trueschema:type:stringdescription:The name of the project.responses:'200':description:Connection string retrieved successfully.content:application/json:schema:$ref:'#/components/schemas/Project''401':description:Unauthorized. API key is missing or invalid.'404':description:Project not found.content:application/json:schema:$ref:'#/components/schemas/ErrorResponse''500':description:Error retrieving project connection string.content:application/json:schema:$ref:'#/components/schemas/ErrorResponse'

API Endpoints

  1. POST: Add Project and Connection String
curl -X POST http://localhost:3000/api/projects \-H"api-key: MOCHA1233" \-H"Content-Type: application/json" \-d'{"projectName": "MyProject", "connectionString": "postgres://your_db_user:your_db_password@localhost:5432/your_db_name"}'
  1. GET: Retrieve Connection String by Project Name
curl -X GET http://localhost:3000/api/projects/MyProject \-H"api-key: API-KEY-HERE"
  1. POST: Fetch Schema Information from a Database
curl -X POST http://localhost:3000/api/fetch-schema \-H"api-key: API-KEY-HERE" \-H"Content-Type: application/json" \-d'{"connectionString": "postgres://your_db_user:your_db_password@localhost:5432/your_db_name"}'
  1. POST: Query a Table with Fields and Conditions
curl -X POST http://localhost:3000/api/query-table \-H"api-key: API-KEY-HERE" \-H"Content-Type: application/json" \-d'{"connectionString": "postgres://your_db_user:your_db_password@localhost:5432/your_db_name", "table": "your_table", "fields": ["field1", "field2"], "conditions": {"field1": "value1"}}'

Get started

First, run the development server:

npm run dev# oryarn dev# orpnpm dev# orbun dev

Openhttp://localhost:3000 with your browser to see the result.

You can start editing the page by modifyingapp/page.tsx. The page auto-updates as you edit the file.

This project usesnext/font to automatically optimize and load Inter, a custom Google Font.

Learn More

To learn more about Next.js, take a look at the following resources:

You can check outthe Next.js GitHub repository - your feedback and contributions are welcome!

About

Create a custom GPT to chat with your PostgreSQL Database in ChatGPT. The most popular DB you can get from Supabase, Vercel, AWS or Azure. Ask Q&A in ChatGPT and refer to database by project name.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published
[8]ページ先頭
©2009-2025 Movatter.jp