# Getting started


### Setup
Create `.env` file with your postgres db vars

```
"DB_HOST": "localhost",
"DB_PORT": "5432",
"DB_NAME": "<table>",
"DB_USER": "<user>",
"DB_PASSWORD": "<password>"
```

1. ``` npm i ```

2. ``` npm run build ```

3. Ensure your server script is executable:
```chmod +x ./dist/server.js```

4. Ensure the shebang line at the top of your compiled server.js:
```#!/usr/bin/env node```

### Setup cursor mcp server:

In cursor go to:
Settings > MCP Servers

```
{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["./dist/server.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "<db_name>",
        "DB_USER": "<db_user>",
        "DB_PASSWORD": "<password>"
      }
    }
  }
}
```

To test run in terminal:
```
echo '{"jsonrpc": "2.0", "id": 1, "method": "tools/list", "params": {}}' | node dist/server.js
```

Once you add it in cursor settings, restart cursor and then reopen and make sure it loads

## To chat
Start a new chat and tell it to use your MCP server

>Give me the first record in the table 
> 
>Do not read my local code files - use the database MCP server instead.