> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pixeltable.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Working with Deepseek in Pixeltable
This documentation page is also available as an interactive notebook. You can launch the notebook in
Kaggle or Colab, or download it for use with an IDE or local Jupyter installation, by clicking one of the
above links.
export const quartoRawHtml = [`
| input |
response |
| What was the outcome of the 1904 US Presidential election? |
The 1904 United States presidential election resulted in a decisive
victory for the incumbent Republican President Theodore Roosevelt. He
defeated the Democratic nominee, Alton B. Parker, by a wide margin in
both the popular vote (56.4% to 37.6%) and the Electoral College (336 to
140). Roosevelt's win marked his first full term in office after
succeeding the assassinated William McKinley in 1901. |
`];
Pixeltable’s Deepseek integration enables you to access Deepseek’s LLM
via the Deepseek API.
### Prerequisites
* A Deepseek account with an API key ([https://api-docs.deepseek.com/](https://api-docs.deepseek.com/))
### Important notes
* Deepseek usage may incur costs based on your Deepseek plan.
* Be mindful of sensitive data and consider security measures when
integrating with external services.
First you’ll need to install the required libraries and enter a Deepseek
API key. Deepseek uses the OpenAI SDK as its Python API, so we need to
install it in addition to Pixeltable.
```python theme={"theme":{"light":"light-plus","dark":"dark-plus"}}
%pip install -qU pixeltable openai
```
```python theme={"theme":{"light":"light-plus","dark":"dark-plus"}}
import getpass
import os
if 'DEEPSEEK_API_KEY' not in os.environ:
os.environ['DEEPSEEK_API_KEY'] = getpass.getpass('Deepseek API Key:')
```
Deepseek API Key: ········
Now let’s create a Pixeltable directory to hold the tables for our demo.
```python theme={"theme":{"light":"light-plus","dark":"dark-plus"}}
import pixeltable as pxt
# Remove the 'deepseek_demo' directory and its contents, if it exists
pxt.drop_dir('deepseek_demo', force=True)
pxt.create_dir('deepseek_demo')
```
Connected to Pixeltable database at: postgresql+psycopg://postgres:@/pixeltable?host=/Users/sergeymkhitaryan/.pixeltable/pgdata
Created directory 'deepseek\_demo'.
\
## Messages
Create a Table: In Pixeltable, create a table with columns to represent
your input data and the columns where you want to store the results from
Deepseek.
```python theme={"theme":{"light":"light-plus","dark":"dark-plus"}}
from pixeltable.functions import deepseek
# Create a table in Pixeltable and add a computed column that calls Deepseek
t = pxt.create_table('deepseek_demo/chat', {'input': pxt.String})
msgs = [{'role': 'user', 'content': t.input}]
t.add_computed_column(
output=deepseek.chat_completions(
messages=msgs, model='deepseek-v4-flash'
)
)
```
Created table 'chat'.
Added 0 column values with 0 errors in 0.00 s
No rows affected.
```python theme={"theme":{"light":"light-plus","dark":"dark-plus"}}
# Parse the response into a new column
t.add_computed_column(response=t.output.choices[0].message.content)
```
Added 0 column values with 0 errors in 0.01 s
No rows affected.
```python theme={"theme":{"light":"light-plus","dark":"dark-plus"}}
# Start a conversation
t.insert(
[
{
'input': 'What was the outcome of the 1904 US Presidential election?'
}
]
)
t.select(t.input, t.response).show()
```
Inserted 1 row with 0 errors in 3.99 s (0.25 rows/s)
### Learn more
To learn more about advanced techniques like RAG operations in
Pixeltable, check out the [RAG Operations in
Pixeltable](/howto/use-cases/rag-operations)
tutorial.